6,934 Topics
 | |
| | One computer can install multiple versions of Microsoft Visual Studio 2005, 2008, 2010, ... so SQL Server Management Studio can install multiple versions of 2005, 2008, ... the same computer ?  |
 | Hi all - also new to PHP/SQL and have a different question on a similar question posted - I need to create a page in php that allows the user to select a date range to and from. Howver, the date stored in the database is unix such as 1494548767 … |
| | 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 …  |
| | Assuming I have file data northwnd.mdf version 2005 I want to convert to file data version 2008 or reverse ? |
 | i have 3 table i inner join with 3 table and add function but now getting error please help me how to solve the the problem please help me ERROR :Msg 8120, Level 16, State 1, Line 1 Column 'TBL_pur_inv.invno' is invalid in the select list because it is not …  |
| | I use below code to backup mySQL database. I want to save sql database by save file dialog. I use this, Sub CreateBackupc() Dim mysqldumpPath As String = "C:\Program Files (x86)\MySQL\MySQL Server 5.0\bin\mysqldump.exe" Dim host As String = "localhost" Dim user As String = "root" Dim pswd As String = …  |
 | I need a list of all 5160 name Indian cities by district name in xls/csv or sql format. Where can I find them?  |
 | sqlconnection = new SqlCeConnection(ConnectionString); sqlcommand = new SqlCeCommand(); sqlconnection.Open(); sqlcommand.Connection = sqlconnection; sqlcommand.CommandText = (@"UPDATE ItemStock_Info SET Quantity =@qun WHERE [Item_Number]='"+ textBox1.Text +"'"); sqlcommand.Parameters.Add("@qun", qun); |
 | Hello, When I try to import this sql into phpmyadmin I am getting this error message: Query SQL: CREATE TABLE `customers` ( `customerNumber` int(11) NOT NULL, `customerName` varchar(50) NOT NULL, `contactLastName` varchar(50) NOT NULL, `contactFirstName` varchar(50) NOT NULL, `phone` varchar(50) NOT NULL, `addressLine1` varchar(50) NOT NULL, `addressLine2` varchar(50) DEFAULT NULL, … |
 | **how to automatically sum the scores that is being inputted in the textbox and display to the specific rows of textbox** > this is my code for inputting score while ($students = mysql_fetch_array($result)) { $total = $students['fld_quiz1'] + $students['fld_quiz2'] + $students['fld_quiz3'] + $students['fld_quiz4'] + $students['fld_quiz5']; echo '<tr>'; echo "<td>{$students['id']}<input type='hidden' …  |
 | Hi, I just need to fetch data from data base from search button on search page and get the result displayed on form in searchresult page.... For eg , if someone has signed up using his phone number or email then whe he enters his phone number or email in …  |
| | 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 …  |
 | hi everyone i need help in my query while user login. <?php $username = $_POST["username"]; $password = $_POST["password"]; $con = oci_connect("user","pswrd","db"); if(! $con) { die('Connection Failed'.oci_error()); } $query = "SELECT username, password FROM users WHERE username=$username"; $stmt = oci_parse($conn, $query); $row = oci_fetch_array($stmt, OCI_NUM);; if($row["username"]==$username && $row["password"]==$password) echo"You are a … |
| | hi everyone hope you all are in good. i have query while login form in php with oracle database..... i want to simple login with database html code: <p> <form method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>"> Username:<br /><input type="text" name="username" size="10" /><br /> Password:<br /><input type="password" name="password" size="10" /><br /> <input … |
 | can anyone tell me code for if i update one record into database for SrNo while using jsp page & if i want to upadet another data for same SrNo then system have to show alert like " u allready submitted data for same SrNo on jsp page |
 | hi, Am a newbie in php,i want to set a countdown timer for online quiz in php. when an student login,there wil be a home page and in home page there are two php pages like quiz.php and result.php, So When the studuent selects quiz.php,he will be redirected to quiz.php … |
| | |
| | hi everyone i need help in my query which is that: 1.which country name i selected from my dropdown list 2.when i select any country_name its show more info in new page.php like (this selected name show more information about country_name e.g. its captical, and cities through database in new …  |
 | Hi, I have a problem where I need to search on data set with 5 fields. Field 1 - Account number Field 2 - Date Field 3 - Person1 Field 4 - Person2 Field 5 - Person3 The data sat contains two months of data (November and October). I need … |
 | I am creating a reporting engine, it is kind of novel. **The only question I have is what are some of the wierder scheduling related things you guys have seen for you cyclical computer programs to date**. I am trying to cover as many fringe cases as I can, and … |
| | 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 … |
 | As I am new to Linq and Entity Framework, I don't know how I add comma sepearted and left join in linq/Entity code. My Sql query is rather big and I want it to be convert in Linq/entity: Select DISTINCT SR.StudentRequestId,SR.RegistrationId,SR.Location,SR.PaymentMethod,SR.CreatedOn,C.ClassName,CC.CampusName, CASE WHEN ISNULL(TSR.StatusId,0)=0 THEN 1 ELSE TSR.StatusId END AS … |
| | Is it possible to make a web page that takes up responsibility for backing up a web applications tables(Oracle DB, and perhaps SQL server I am trying to be multi db supportive)? Essentially I want to create a database backup script that is kicked off by pressing a button on … |
 | Hello ! I have a task from my university that bothers me and I definately need some help. I have to create a web app in which i can add locations from the world map by taking the coordinates and make route between two selected locations from the added. Also … |
 | 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 * … |
 | 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 … |
 | Dear Friends, i Developed a C# Project with SQL Server Database (Database is not LocalDB) and i want to create a setup file to install on client system havin windows xp 32bit. Please suggest me how to do it ? |
| | how to Generate Auto Alpha numeric Inv. number in SQL Store procedure i used Sql Server 2008 r2 and vb.net 2012 I got a error ---- *Msg 245, Level 16, State 1, Procedure P_GetAutoIDPurchaseInv, Line 13 Conversion failed when converting the varchar value '17-18/00002' to data type int. * When …  |
| | After installing win7 and install SQL 2005 opens the error, see the video attached: http://www.mediafire.com/file/wmuzvn8wx3yii0u/ErrorConnectSQL2005.swf you know how to fix this error ? |
| | Suppose you have 3 tables: TABHDBH, TABHDBHCHUYEN and TABHDBHCT Table TABHDBH has the following fields: NGAY DateTime; IDHDBH int ... Table IDHDBHCT has the following fields: MAHDBH int ... TABHDBHCHUYEN NGAYCHUYEN datetime MAHDBH int ... RELATIONSHIP OF 3 TABLE TABHDBHCHUYEN.MAHDBH head n TABHDBH.IDHDBH head 1 TABHDBHCT.MAHDBH head n DELETE T1 … |
| | So here is my problem laid out as simple as I can put it. I cant combine multiple entities together that have related data but are different (one database table has id number that is shared by database table 2 and table 2 has employee number which is shared with … |
 | hi frinds. hope you are well. as i writte this writting im thinking about a my [site](http://Iraniantranslate.com) .... how can i introduce my site to other people? and how can i popular it in google search? best regards,  |
 | What I'm trying to do is have a login type windows form to take a user name and password then compare these with data in the db then open an admin type form. I've been trying to get this to work for a few days now with no luck, about …  |
 | 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 … |
 | Good day! Could you guys give me link or any tutorial about using parameterized query esp. in CRUD, I'm developing an enrolment system and I'm using C#.net and Mysql database.. I hope you can help me. TIA |
| | How to Update Sql database from vb.net 2010 i want to add a stored procedure in sql database from login time on button click.. **database name ** db17-18 **stored procedure** Create Proc P_SelectAllRole As Select StatusId,Status from tblStatusMaster  |
 | i need to update when user i come on left or right side if colums in table when user come with register then count leftcount 1 , if user come right side then count , in colum rightcount . plz any person can help me? |
 | Hi guys, I'm fairly new to angularjs 2 (I've only used 2) and I have a small application with a form. Currently I'm able to get the form data as an objects and print it to the console.log, onSubmit(form: any):void{ console.log(form); } producing this: Object {author: "Author test", title: "Title … |
 | I am looking for a mysql query to search and list most common pairs with their IDs and number of occurence. Thanks. |
 | **USE SELECT...WHERE FOR TEXT FIELDS IMPOSSIBLE** I use SELECT search with WHERE fieldsname by VARCHAR imposible. But good use with INT fields. Why's that. Please tell me about it . My code as : <?php mysqli_select_db($connect ,'simple_login'); $sql = 'SELECT * FROM table where username= hai ' ; $retval = … |
| | 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 … |
| | 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 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 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 … |
 | I want to start a website like hippofile, cnet download, filehorse or freewarefiles in Wordpress Anyone who knows a Wordpress theme with which that I can build a website like hippofile, cnet download, filehorse or freewarefiles in Wordpress Many thanks  |
 | I have a table with nutrient data(in Dutch) it looks like this  My DB design skills are very low, I only know Mr. Codd is lurking 'round the corner somwhere. Could anyone give me some hints on how to set up my tables or should I just usr … |
 | 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 … |
| | I haver an IIS server with an mvc 5 app im developing and i have had no luck so far getting the windows authentication working with my app, i have it set to windows authenication but the app will only auto login users when accessed from the server. Then once … |
The End.