6,934 Topics
 | |
 | i have wrote query to calculate TOTAL WORK TIME and Overtime of an employee based on Intime and outTime but can't figure out to put another column 'IsAbsent'. e.g. if person doesn't come on any specific date than his INtime and TimeOut would be empty then if both are empty …  |
 | Structures of my tables are as follow. Table Name : timetable [Image1](http://www.4shared.com/download/MYafV7-6ce/timetableTable.png) Table Name : slot_table [image2](http://www.4shared.com/download/9Lp_CBn2ba/slot_table.png) Table Name : instructor(this table is not required for this particular problem) I want to show the resultant data in my android app in a timetable format somewhat like this: [image3](http://www.4shared.com/download/oAGiUXVAba/random.png) **Question** : … |
| | Successfully calculated TotalTime a person has worked and overtime he has done if total working time is greater than 08:00 but if not greater than it puts duration of time person has not worked in Overtime column BUT NOW overtime column should display that time in proper negative format e.g. … |
| | How to dynamically add div in asp web page ?ie, if mssql server returned n rows from a query, i must place all these n rows in seperate div which has to be created dynamically.!!pls help (d case is when displaying search results in a web page like shopping sites)  |
| | i am given task to analyze and modify pre written large queries within small time, so please help me understanding it with times as ( SELECT t1.EmplID , t3.EmplName , min(t1.RecTime) AS InTime , max(t2.RecTime) AS [TimeOut] , t1.RecDate AS [DateVisited] FROM AtdRecord t1 INNER JOIN AtdRecord t2 ON t1.EmplID …  |
| | hellow every body i need sql comand works in vb6 with windows7 thank you  |
 | Hello, I need some help here. I cannot make the right query. In my code, I want to insert a data into my database. But the id_number will have different values. Id_number have different values because its from a group. So with that group of id_number I want to insert … |
| | i've been working on a program and i want it to be accessed by multiple users. so i have an admin account and an other users account what i want to do is for the other users to be able to access the program and its database from another computer …  |
 | If someone can provide a link with the use of Parameters instead of concatenation  |
| | i created a pl/sql program in which i want to take multiple inputs from user.. i wrote that n:=&n; in a loop ,i though it will take,but its not working... is there any way to take multiple inputs from user in oracle???? |
| | Hi, I have mysql database dump xxx.sql How can i convert xxx.sql to xxx.csv? Thanks  |
| | i need to generate for example the January month from 1-1-2014 till 30-1-2014 in sql database using visual basic 2010 so the table will be like that Date Day Employename 1-1-2014 Wednesday elie 2-1-2014 Thursday elie 3-1-2014 Friday elie , , , , , , , , , , , … |
| | Hi. I have a mysql field with a record like: [2,5,11]. I have a query like: $query = $this->select() ->from($this->_name) ->where('id = ?', $id); This query work if record is of integer type: 5. Is it possible to create a query to find 5 in the array? Please advise. Thanks. |
 | i want to know how to create database when there are check boxes. i also want to know the codes to connect those checkbox values to database and retrieve from database. this is my part of my html code. <tr> <td>Professional Qualification <br /></td> <td style="height: 78px"> <input type="checkbox" name="Charted" …  |
| | sir i am using VB6.0 POS software, i want to know the source code of the software. Regards! Khawar  |
| | @ by : O This is topic (http://www.codeproject.com/Articles/21351/Import-Data-to-SQL-Server-from-Excel-or-Access-usi) is reactivated again which was posted by : Oxiegen for further information: The code is corrected but the data is not getting exported from Access database to SQL. The code is as follows : Private Sub Button1_Click(ByVal sender As System.Object, ByVal e … |
| | Recieving the error "Dynamic SQL generation is not supported against multiple base tables." When pressing the save button Code for Save button: private void btnSave_Click(object sender, EventArgs e) { DataGridQuestions.EndEdit(); adapter.Update(ds, "Questions"); MessageBox.Show("Updated"); DataBind(); } Code for filling data adapter private void DataBind() { string connectionString = ("Data Source=" + … |
 | I have 3 comboBox.. and i wanted a code for the thirdcombobox , something like "SELECT companyName FROM table where mainCategory = firstcombobox and subcategory = secondcombobox" , how do i do the sql query? my maincategory combobox is called mainCatU , and the subcategory is subCatU I managed to …  |
 | I have this project where i have to create an events website using a mysql database and php. I'm having some toruble with some code that will allow users that change their password. I know it's a problem with the mysql syntax in my query but i can't figure out … |
 | Hi I have to create an sql database for work, for my students to work with. I have created a large portion of the program, but i am stuck on the searching of data. So searching for a person or department. Not sure how to do it, here is my … |
| | I have following quary example. SELECT t1.TeamID, MemberList = substring((SELECT ( ', ' + FirstName ) FROM TeamInfo t2 WHERE t1.TeamID = t2.TeamID ORDER BY TeamID, FirstName FOR XML PATH( '' ) ), 3, 1000 )FROM TeamInfo t1 GROUP BY TeamID Its giving error "Incorrect syntax near the keyword 'FOR'." … |
| | I wrote a sample program in notepad begin dbms_output.put_line('welcome'); end; / and saved it as p1.sql i opened sql prompt and gave @p1 it didnt worked??? i tried exec p1; still not working?? how to execute a pl/sql program???pls help |
| | Hi there i want to know whats the difference b/w databanks like sql and our own text structure txt file that could easily store data even with less size than databanks. Of course i now sql is faster secure and much more but i can encrypt my data too and … |
| | Hi I want to do a silent install of sql express 2008 (free edition) In my configuration file, how can I set the default language to British English and date format to "dd/MM/yyyy". Thanks for your help SQL Newbie |
| | Guys, please suggest me, how can I set up an audit on SQL server 2008 if I need to track who, when, what and from where changed something on a database table? |
| | Good day, I need help with my ajax based dynamic drop down list. Right now, ajax.php pulls up data depending on value at a single column. I need it to pull up data based on value at certain columns. I am new to php and its going over my knowledge. … |
| | Below tables :I am trying to calculate **openLeadsCount** having status 1 I tried but getting wrong results SELECT COUNT(lead.id) FROM lead JOIN lead_status ls WHERE ls.lead_id=lead.id AND ls.id=(SELECT MAX(id) FROM lead_status lst WHERE lst.status=1 ) Lead table: id created_on 1 2014-1-13 2 2014-1-18 lead_status table id lead_id created_on lead_status 1 … |
| | I am trying to use sql to sum a column in my access database and put the result of this in a text box. The code I have got is the following, but this is coming up with the error below. [QUOTE]Error : Conversion from type 'DBNull' to type 'String' … |
| | *new to C#* I have created a form , with a working coding , but i need an extra assistance. Somewhat , i am stuck on trying to figure out how to let the 3rd combobox value , determined by the first and second. Like this : [Main Form](http://i.imgur.com/1rePOge.png) For … |
| | I only have experience using pretty basic Oracle. However, I'm now in need of a better understanding of SQL. I'm trying to write a query using CASE statements (as this seems to be the best approach), but am admittedly lost at the moment. Here is what I have as a …  |
| | I am doing an investigation in to cross site scripting and sql injection and maybe other attacks for my thesis basically looking at vulnerabilities in websites that could potentially cause these attacks, I am struggling to come up with ways in which to demonstrate this. Intially I was thinking about … |
| | Hi Experts my excel data is copied successfully to the listview. But on importing to database, I get this error. InvalidArgument=Value of '5' is not valid for 'index' ParameterName:Index ================= I have 2 problems ================= Problem 1: What should be the problem when I importing from listview(I think it is … |
| | I receive this error  when I have this code: Private Sub EditUsers() Try Dim dt As New DataTable dt = ExecuteQuery("UPDATE tblUsers SET UserID = " & txtUserID.Text & ", UserName = '" & txtPassword.Text & "', Password = " & txtPassword.Text & ", LastName = '" & … |
| | I have created a form , with a working coding , but i need an extra assistance. Somewhat , i am stuck on trying to figure out how to let the 3rd combobox value , determined by the first and second. and what i wanted is , something like , …  |
 | hi any one with an idea on how to create user ineterface of sql oracle database.  |
| | Hi there. I was kinda researching on how I could store data at best (in my opinion). I came on "CSV" files. Which looked great to use. I found out there are two functions that can operate file. So I keep Googling on how to use the syntax and how … |
 | hi guys... i am working on the project in vb.net in visual studio... my computer's name is homesys(Computer name as shown in MY Computer Properties).... when i try to make crystal report using sql server 2008 database... which i made it in visual studio itself, i am unable to get … |
| | Hi I have data to upload to a Mysql database and I need to get the time taken for each row to be inserted so that I can pass that number through to a progress bar. I have alreay tried accomplishing this by determining the number of rows affetced by … |
 | I have data already populated in a datagrid I have three textbox txtCustomername, txtPartcode, txtinvo I want the user to be able to input text into the txtcustomername text box which will result in the datagrid only showing the rows that relate to that customer. Then I want the user …  |
| | Hi Guys I need to create an SQL database for my work, and use visual c# to build the application. I work for a college and we have just opened up an IT support shop that is run by the students. They need a database created, but I am unsure … |
| | [CODE] try { Class.forName("oracle.jdbc.driver.OracleDriver"); Connection con = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl", "scott", "tiger"); if (con == null) System.out.println("Connection not successful"); else System.out.print("successful...."); con.close(); } catch (Exception e) { e.printStackTrace(); } [/CODE] Error: [CODE] java.sql.SQLException: The Network Adapter could not establish the connection at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:412) at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:531) at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:221) at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32) at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:503) at …  |
| | Below is the code I am using: Dim safe10_comp As Integer Dim ref_date As Date Dim dr As DataRow Dim dt As DataTable = New DataTable() Dim da As OleDb.OleDbDataAdapter = New OleDbDataAdapter() Dim Conn As OleDbConnection = New OleDbConnection(System.Configuration.ConfigurationManager.ConnectionStrings("ConnectionString2").ConnectionString) Dim sql As String = "with a as (select t.employee_number, … |
| | Hello. I meed some help with this. I am trying to delete a record from database(SQL Server) Am i missing something? Private Sub cmdDelete_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmdDelete.Click _DataSet.Tables(0).Rows(CInt(txtCurrent.Text) - 1).Delete() ' tho, it can remove the deleted rows ' we cannot call the DataSet.AcceptChanges …  |
 | Hi All Daniweb PHP Group, I have a big favor to ask (well for me this is big lol). I have 3 databases first (LOCAL),(AIMIS),(ERM). Here's the table (namely account_manager) of LOCAL.  and Here's the table (namely customer_call) of AIMIS.  and Here's the table (namely quotations_header) … |
 | Hello I have two tables: Students and Professors (both with usual info like name, last name, email... etc) I also need to have info about their knowledge of foreign languages, and I guess that should be a third table (languages for example) it should look like: Language_id, Language, Speaking, Writing, … |
 | Hi Anyone can explain whats means with this vulnerability(Blind SQL Injection) and explain Attack details 1 and 2? 1. This vulnerability affects /xxxx/. Discovered by: Scripting (Blind_Sql_Injection.script). Attack details Path Fragment (suffix .html) input - was set to -1' or 61 = '59 2. This vulnerability affects /xxxx/. Discovered by: … |
 | i am trying to get all the result from my databse table but this query is not working. <?php try { $pdo = new PDO('mysql:host=localhost;dbname=articles', 'Avik', ''); } catch (PDOException $e) { $output = 'Unable to connect to the database server.'; echo $output; exit(); } try { $sql = 'SELECT … |
| | Hello Friends, I have a table which says stores 4 values id,publisher name,bookname,time I am firing query like SELECT * from table where time>='sometime' group by `publisher name` order by time DESC What I want is to select results in DESC order of time with unique publisher name. When I …  |
| | hello every one,,,ihave no experience in c# and iam designing a c# app that insert,update,delete and select data from and into remote database using sql server 2008,so i want some tutorials about c# connection with sql server please help me and thank you.....  |
| | hi friends....... i am doing a project in c#....... i need a urgent help...... i want to store all kinds of file(.doc,excel,bmp) in sql server 2008 in a single button click......the number of files to save depends upon the user...so i dont know how to create taable fr this and …  |
The End.