6,934 Topics
 | |
 | Hi There, This comes under a few forums on DaniWeb, so I've guessed and posted it here... I have two computers, both connected to the internet and running Windows 7 (Home Premium + Professional). One is my main one, the other is one I do not use. If I installed … |
| | I have table as follows C Common Code 337080.00 15 Jan 2014 14 Jun 2017 Ananth Krishnan ee C Common Code 337080.00 15 Jan 2014 14 Jun 2017 Balaji Srinivasan ee C Common Code 337080.00 15 Jan 2014 14 Jun 2017 Deepa Venkitesh ee C Common Code 337080.00 15 Jan …  |
 | studentmgt.php $search = $_GET['search']; echo $search; ?> <div align="center"> <div style="width:700px;text-align:left;padding-top:5px;"> <?php if (isset($confirmation)) { echo $confirmation; } ?> <form method="get" action="<?php $_SERVER['PHP_SELF'] ?>"> <br/> <?php //LOAD STUDENTS INFO $result = mysql_query("SELECT * FROM `student` INNER JOIN `group` ON group.group_id = student.group_id INNER JOIN `access` ON access.access_level_id = student.access_level_id ORDER … |
| | int counter; counter=1; rs = statement.executeQuery("SELECT * FROM Quiz WHERE SrNo=counterr"); |
| | I am exporting data from excel and show it in gridview and when I click submit, it needs to be updated in existing table. Below is my excel data S.No. RequestID Subdivision No Parcel No CUID Status Remarks 1 5 42 55 55 Open Pending I have successfully exported and …  |
| | This the following code for member_account.php in the member_profile.php there is a link for member_account.php, after I login then i can see all information and in the headbar it shows username,account logout home link. but whenever i click to account I can see only logout and home link (i made … |
| | Hi guys i have an sql query string that in my view there is something wrong with it but i an handicaped since i am very new to sql so my question is, is there any way of optimizing this query string select t1.cat,t1.site from (select cat,site from news where …  |
| | |
| | I am making a erp using WPF-C# and i have a confustion on how can i connect my app to sql server after compiling. I am asking this because my app connects to DB when i compile it with Visual Studio and SQL server is already installed on my pc, …  |
 | A report from Hold Security claims that one of the biggest ever online heists has been committed by a Russian crime gang. It would appear that the data theft includes, wait for it, no less than 1.2 billion (yes billion) username and passwords along with around half a billion email … |
 | Hello fellow daniwebians, I'm attempting to wrap up an asp.net/c# eCommerce website recently created (recently discussed in many of my posts). I'm now trying to transfer the finished product from my local development environment to a remote host. I can publish the files fine, I can reset the connection-strings as … |
 | Hi, > I want to know how to store and retrieve picture path from sql server. Can anyone show me the code please. |
| | I have a question about how to set up a page in php to allow the user to create reports from a mysql database and display in a grid on the page. I want them to build the query and save it to the another table and list on their …  |
 | IQueryable<CustomObject> obj = (from table in db.TableName orderby table.ObjectId descending select new CustomObject { //Properties mapped here }).Skip((pageNumber - 1) * pageSize).Take(pageSize); The above is a stripped down version of the query I am running. It is missing about 10 joins and then just the bulk mapping of the object, … |
| | Hi, i am trying to extract values based on range of dates. Why i am getting this error Invalidcastexception was unhandeled **Conversion from string "SELECT * FROM TBLRequest where T" to type 'Long' is not valid.** for below string **FlexString = "SELECT * FROM TBLRequest where TBLRequest.PrDate >='" &** **Date.Parse(TxtDateFrom.Text) … |
| | Hey guys I really need some help if you can ASAP, my website is now done and this is the last thing that needs to be sorted.... I seriously need some help. I have added in 80 questions into the database. The website is a learning aid for users like … |
| | http://stackoverflow.com/questions/5846/add-1-to-a-field Didn't really work. My script looks as follows: <?php if (isset($_GET["id"]) && isset($_GET["char"])) { $id = $_GET["id"]; $char = $_GET["char"]; $result = mysql_query("SELECT * FROM battles WHERE id='$id'"); if ($char == "1") { $bool = "first_char_votecount"; while($row = mysql_fetch_array($result)) { $mincemeat = 1 + $row["first_char_votecount"]; } } elseif ($char … |
| | This i sdriving me nuts and I know there should be an easy answer. Here is the php $sql4 = 'select tranamt, tracct from bd.bdptran where bd.bdptran.trnum = 105 '; $result4 = db2_exec($conn, $sql4); while($row4 = db2_fetch_array($result4)) { echo $row4[0] ."<br />"; echo $row4[1] ."<br />"; } I get the … |
| | Hello guys I'm wondering how to update rows dynamically for instance: if cart contains one product then update its quantity and if cart contains more than one product update their quantities |
| | Hello guys I've coded cart class with cart items and showed cart items in a table but I had a problem when I try to update the cart.. It updates all the cart items when I'm changing quantity in one of the items **HTML** <div class="cartContainer"> <h1 class="shoppingBag">your shopping bag</h1> … |
| | I have a connection in a DAL to SQL server. Using this connection I am trying to read the query. I have tried using ExecuteReader() and ExecutreNonQuery() with no luck. Here is my code: private void button1_Click(object sender, EventArgs e) { try{ var cn = new Connection_Handler(); string input = … |
| | select SUBSTRING('hello ä¸–ç”°è°·åŒºçµŒå ‚ä¸–ç”°è°·åŒºçµŒå ‚ ',5,10) as Japanese gives output as "o ????????". Is there any way i can get the substring of above string ? Thanks in advance for your help. |
 | I have an issue with accessing a table in my database after using the truncate command on it. Having to delete the whole database and recreate it not every time but often. The table is used to hold the index of a card and the card's value. This is the … |
 | I tried to create the database connection SQL Server 2008 R2 Express with ODBC connection using TCP / IP After I try the following error appears : Connection failed : SQLState : '01000 ' SQL Server Error : 10060 [ Microsoft ] [ ODBC SQLServer Driver ] [ TCP / … |
| | This is my first time using dynamic sql. My goal is to populate a datagrid with a stored procedure that uses a incoming parameter that equals a column name in the table. I have 2 problems. 1. I can get each sql statment to execute independently with the correct results. … |
| | ** Hello i am newbiw to MYSQL .... iwant to create stored procedure in PHPMYADMIN . But when i am same procedue od MS SQL in MYSQL it is giving error . #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL …  |
| | Hey guys, having a bit of trouble with a customized eCommerce. The part I want to focus on is the adding of an item to the shopping cart (and the details that go along with each item). Everything works as is with the things I need commented... initial call to … |
| | Hello, I am currently completing a side project. The biggest ideal of it all has to do with a dynamic drop down box. I have heard and seen of the 'auto complete textbox' feature by using ajax/jquery toolkits. That is what I'm looking for, but I was wondering if there …  |
| | Hello, I have field in db table which have real datatype in SQL 2005. I want to convert it into time (HH:MM) format and add to another time. ex: 0.3 (convert it to 00:30) and want to add into 17:45 so i can get 18:15 0.45(convert it to 00:45) and … |
| | Hi there, I'm in the process of creating a utility program that builds a table in a database and inserts the initial data. I'm getting an error stating: java.sql.SQLException: No suitable Driver found for jdbc.odbc.ContactKeeperDB My Code: [CODE] import java.sql.*; import java.io.*; public class MakeDB { public static void main(String …  |
 | any help for deploying sql database while setup c# application |
 | Hy now i have this code <div class="row"> <div class="col-xs-12 col-md-6 left"> @if(in_array($profile->Entity_Id,$likes)) <a class="btn btn-sm btn-primary" href="{{URL::route('displayProfile',array('profile_id' => $profile->Entity_Id))}}"> <i class="icon-visual-eye-fill icon"></i>1</a> @else <button type="button" class="btn btn-sm btn-primary view-profile" profile-id="{{$profile->Entity_Id}}"> <i class="icon-visual-eye-fill icon"></i>not</button> @endif </div> <div class="col-xs-12 col-md-6 right"> @if(in_array($profile->Entity_Id,$likes)) <a class="btn btn-sm btn-info" href="{{URL::route('messageProfile',array('profile_id' => $profile->Entity_Id))}}"> <i class="icon-envelope-fill-1 … |
 | I am developing a project on PHP and MySQL. My problem is "I am unable to show a uniqueID in a textbox like 'GHY00001, GHY00002, etc' auto-incremented everytime i load the page and insert it into the database". I already tried some php tutorials but didn't find usuable to my …  |
| | '====================================================================================================== '====================================================================================================== Option Explicit 'For Log ID Public RUNNINGID As String Private Sub butBrand_Click() On Error GoTo ErrorHandler Dim colData As New Collection frmSearch.SQL_Statement = "SELECT ROW_NUMBER () OVER (ORDER BY brand_type_code) AS [NO.] , " & _ "[brand_type_code] AS [Brand Type] , " & _ "[brand_type_name] AS [Brand Name] …  |
| | I'm implementing something similar to a shopping cart - a "my favorites" page for products. Users can click on an "add to favorites" link and add products to a favorites table from which they can view the details of those products at a later time. There's no purchase on the … |
| | HI can any one please help me how to convert timestamp to IST jtime = 2014-07-23 02:41:05 to Date H:i:s am/pm formate  |
| | I am currently working on an online website which houses a database inside that has 50-75 fields. I have what I believe may be a somewhat rudimentary question. Assuming we want to query the Database how would one go about making it so it builds a query statement using the … |
| | I'm trying to create my own Database and Tables in SQL Server 2005 using VB.NET 2005. I get an error when I try ExecuteNonQuery, which says that the connection is not initialized. I'm not sure if I'm doing any of this right. Any help would be greatly appreciated! Sheryl [code=vb] … |
| | My requirement is to select a supplier name from a Dropdown list(DropDownList_Supplier) and use the value to get Supplier id from the table "[SQS].[dbo].[Services]". I am using the below code and i am not able to get the value in the required field. Public SUPTEXT As String = "SELECT [ID] … |
 | Hi guys, Im very new to vb.net. I have this project that I'm working on Just to get more insight and appreciate programming. Now the problem I'm getting now is how to save the picture already selected to my picture box into the database (sql-server) this is my datase: memberID …  |
| | Hi Everyone. Background :- Winform App creates database in MSSQL LocalDB & creates tables. Data is imported & analysed then report is created. At any point in the process the user can start a new project & tables are removed to be re-created later as the user progresses through the … |
 | i have a prinscreen of the problem http://i.imgur.com/GMJho9r.jpg i use mySQL to create the query and i have a database called tap that contains the events table I try SELECT sensor_id,event_type,value from tap.events where events.time = (SELECT MAX(events.time) from tap.events) group by sensor_id,event_type ORDER BY sensor_id,event_type; I get only the … |
| | I am trying to insert some values into a database and I have the following SQL: insertString = "INSERT INTO SocialHistory (ExamID, Occupation, SafetyYN, ComputerYN, ComputerHrs) Values('" & CurrentExamID.ToString & "', (SELECT Occupation, SafetyYN, ComputerYN, ComputerHrs FROM SocialHistory WHERE ExamID = '" & LastExamID & "'))" When I execute the … |
| | hi..can somebody help me? how can i have a conditional join in my statement. i have a parameter to be passed to the SP: @pRemarks my main query: select * from MasterList if @pRemarks='ALL' then my query will be: select * from MasterList inner join tblPositionLists on tblPositionLists.Position = MasterList.Position … |
 | |
| | Greetings, I'm trying to setup the SQL Server 2008 Express Edition using a command line Setup.exe /QUIET="False"/QUIETSIMPLE="True" But I always got a message saying that QUIET expects a Boolean value and what I'm passing to it is a Boolean value do any one knows what I'm missing |
 | Hi, I want to Count the number of occurences of data in a table, then multiply it in a value from other table, After that I want to sum up the product of count and the value from other table, As of now, I cant count and then multiple but … |
| | Hi there, wanna ask if the sql syntax order by and group by the same? eg: i have a dropdownlist and the values displayed should be in ascending order. hence is there any difference if i use these 2 sql statements below. [CODE]sql1 = "select distinct * from t_staff group … |
| | Hi, can someone explain to me why my code is returning wrong output. I want this code, First I have additional UPDATE query for a category 10, if it is not category 10 then it should ignore the update code. It is running correct if I input an item which … |
 | I'm working with a MS SQL database that was done by another developer. Im developing a website that interacts with that database. I need to use a stored procedure called LoginR that takes 3 input parameters (LoginName and Passwords) and returns the NickName in the third value. But also, has … |
The End.