2,935 Topics
 | |
| | Hi , i have two jsp forms ,one is student1.jsp and student2.jsp in student1.jsp name ,fathername,mothernames are input fields and student2jsp brothername and sistername's are there one database student(name ,fthername,mothernames,brothername ,istername's) what i want is to store two forms data into onedatabase . is it possible?then how?. |
| | So I am really interested in making a database, I have knowledge about html and css, not javascript and I just want to begin learning and making a database. I am going to use this website: https://www.000webhost.com/?utm_source=000webhostapp&utm_campaign=000_logo&utm_medium=website&utm_content=footer_img so you can see my website in the internet, I don't really expect …  |
| | My data SQL Server is reported this error, How does this error fix you ? SQL Server detected a logical consistency-based I/O error: torn page (expected signature: 0xaaaaaaaa; actual signature: 0x5555aaaa). It occurred during a read of page (1:210768) in database ID 7 at offset 0x00000066ea0000 in file 'G:\Database\MyData.mdf'. Additional … |
 | Show error when I login to the SQL server management. First, I change the server name. Second restart the server/1st stop services the start services. Then I check the server name SELECT @@servername AS 'ServerName' using this line the show new change server name. Then I closed the window of …  |
| | Hi there here is a stupid question. I have created an update statement that updates a table that has null user id using a name as the identifier: [CODE] UPDATE dembel SET userid = 8908 WHERE [Name] = 'o'reily' [/CODE] However the the name already contains an apostrophe which causes … |
| | I have a sp in mssql which gives multiple resultsets.I need to display the result in html table using php . I am using mssql_fetch_assoc() & mssql_next_result(). How to store each resultset in a array and retrieve it. $result=student_sp('1231','1') do curlybrace while($row=mssql_fetch_assoc($result)) brace $name=$row[name]; $age=$row[age]; $marks=$row[marks]; $term=$row[terms]; $Subject=$row[sub]; $html="<table><tr><td>$name</td></tr><tr><td>$age</td></tr></table>" $mark="<table><tr><td>$subject</td></tr><tr><td>$marks</td></tr></table … |
| | ** Cannot open MSSQLSSQLEXPRESS service on computer'.'. ** **What I have tried:** Dim myController As New System.ServiceProcess.ServiceController("SQL Server (SQLEXPRESS)") ------------------------------------------------------------------------------------------------------------ Private Sub Service_status() If myController.Status = ServiceProcess.ServiceControllerStatus.Running Then TextBox1.Text = "Started" ElseIf myController.Status = ServiceProcess.ServiceControllerStatus.Stopped Then TextBox1.Text = "Stopped" End If End Sub ------------------------------------------------------------------------------------------------------------ Private Sub Button2_Click(ByVal sender As System.Object, … |
 | Can anyone help me with a SQL string ? or point me in the right direction? I have a colum called ctn_node_path which has results like PARTS & ACCESSORIES > PSJOHNSON - SEDDON JOHNSON PARTS > JN - JOHNSON PARTS I am trying to split the string into three PARTS … |
| | Hi, I would like to ask a question about returning the column value(s) returned by stored procedure in c#. I have created the code but somehow I encountered an error saying: ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ An unhandled exception of type 'System.Data.SqlClient.SqlException' occurred in System.Data.dll Additional information: Subquery returned more than 1 value. This … |
 | using the following code i get an error from line 5 my error is Fatal error: Uncaught PDOException: SQLSTATE[08001]: [Microsoft][ODBC Driver 11 for SQL Server]Named Pipes Provider: Could not open a connection to SQL Server [53]. in C:\xampp\htdocs\dailysales\includes\CPeriodOrdersJson.php:5 Stack trace: #0 C:\xampp\htdocs\dailysales\includes\CPeriodOrdersJson.php(5): ->('sqlsrv:Server=F...', 'LocalAdmin', 'CrispyCrackers') #1 {main} thrown in C:\xampp\htdocs\dailysales\includes\CPeriodOrdersJson.php … |
 | I have a couple of SQL databases that i am trying to link results from. My first database is calendar that i need to return the details for today so current date and targets for sales and orders that works my second data base is for orders which i can … |
| | I am using a code similar to the one below inside my stored procedure: [CODE]declare @tempVar decimal select @tempVar = amount from tempTable where <<conditions>> IF (CONDITIONAL STATEMENT) BEGIN select @tempVar END [/CODE] now I am supposed to be getting 4.25 something and I get 4, when I can clearly …  |
 | 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...  |
| | 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 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 …  |
 | All information related upcoming ERP Cloud systems by Oracle  |
| | 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 …  |
| | 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 … |
 | 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 …  |
| | 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 have a website name onlinecheckwriter.com which helps my client to print check online. Right now I'm facing one problem that I didnt find any vendor that provide offical routing never verification api. Right now our customer add routing number but I need cross check it with bank . So … |
 | 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 … |
 | 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() … |
 | **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 …  |
 | 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 … |
| | Hi I am trying to populate textbox value based on releated textbox value like that of (Country and State) using dynamic row formate. I can able to populate a value for only first row, if i tried ti for second row its again overwrite the first row and also i …  |
 | To all database genius out there, I hope you can help me with this error I encountered when importing excel file to SQL Server 2005. This is the error: [CODE]Executing (Error) Messages Error 0xc020901c: Data Flow Task 1: There was an error with output column "Description" (21) on output "Excel … |
| | I am trying to cast/ convert varchar to a numeric value. I have done this succesfuly when I eval the lower range, however I get an error when I do the upper range. this is my evaluation section that works. isnull(cast(measurmentdata.measvalue as numeric),0) < productinfo.lowerrange however when I try to … |
| | Good day, I having a problem where creating my setting table as condition below column User_id setting effective_date effective_end_date Row 1: 1 ABC 2017-03-01 2018-02-28 Row 2: 1 DEF 2018-03-01 2019-03-01 I wish to add a constraint to block if same user add in a setting with the effective_date or … |
The End.