6,934 Topics
 | |
| | Hi, I have been searching and trying for days now but still cant get this to work. Id like to group my result from a SQL call into a multidimensional array. The columns that are extracted are Timestamp, room, device and value and gets sorted accordingly. As long as the … |
| | Hi, I have been searching and trying for days now but still cant get this to work. Id like to group my result from a SQL call into a multidimensional array. The columns that are extracted are Timestamp, room, device and value and gets sorted accordingly. As long as the … |
| | Hello, I am trying to learn c# and sql server and I am not sure how should I proceed in the following situation: I have a database with 2 tables: Clients and OrdersFromClients I am trying to make a form with a listbox in which I will display all the …  |
| | |
| | Hi , i need a sample code for Export data from MS-SQL to Notepad.txt using vb.net in Pipe line format this is my sample table data ID Name Address 1 Meenu Meenuhouse 2 Ammu MeenuHouse 3 Chinnu Meenuhouse i need output like 1|Meenu|Meenuhouse 2|Ammu|Meenuhouse 3|Chinnu|Meenuhouse Can any one help me … |
| | hi. few days ago I open a microsoft azure account and create a virtual machine. download SQL server managment and do everything ready. open TCP port 1433 and my DSN name is btca.cloudapp.net now I cant connect with the database inside it... what to do. Im looking everything but nothing … |
| | hi. few days ago I create a Azure account and create a Virtual machine. download and install SQL server managment, open TCP port 1433. but cant connect to my app.. my DNS is btca.cloudapp.net but cant connect. tried to connect with DSN & IP but nothing happening. any suggestion? |
| | hi. few days ago I create a Azure Account and create a Virtual Machine install SQL server managment. open TCP port 1433. but now I cant connect to my app... my DNS is btca.cloudapp.net but cant connect the code with the database... please help me... |
| | So I have this simple query that if I run it on sql server management studio it gives me results. Select name, count(*) As thecount from Restaurants group by name I am using codeigniter and a wrapper library for datatables called [ignited datatable](https://github.com/IgnitedDatatables/Ignited-Datatables/wiki/Function-Reference) . I am using it because its … |
| | Hi guys I make program to select data every day automatically by timer every second in c# In sql server 2005 i write the following query ALTER proc [dbo].[JeddahSalesAll] as SELECT ROW_NUMBER() OVER (ORDER BY dbo.[Jeddah-Live$Sales Header].No_) AS [S.N], dbo.[Jeddah-Live$Sales Line].[Document No_] AS 'OrderNo', dbo.[Jeddah-Live$Sales Header].[Bill-to Name] AS 'CustomerNo', dbo.[Jeddah-Live$Sales …  |
| | SQL Gurus, help !! I have a table with 3 fields, ID, Answer_5, Answer_6. Answer_5 & Answer_6 both hold a date value, but the fields are defined as string (for other reasons). In Answer_6 it is possible to have the string of 'Now'. I am trying to do a simple …  |
| | I have images generated by while loop php based on how many course user have when user press on one of those images it will send him to that course page but all images send to one course page this my php code in** home page ** <?php $con=mysqli_connect("localhost","FYP","123","FYP"); $sql= … |
| | hi guys, i had an account on Daniweb but forgot password and recovery was a bit hectic so decided to crreate a new account. the previous username was emma etigu. i have a problem and need some help. below i have two tables from my dataset, i would like to … |
| | Hello, I was wondering if the following mysql query can be constructed in a much more efficient way? SELECT distinct(cr.email), m.fname, m.lname, m.email, (SELECT count(*) FROM campaignRecipts where email=cr.email )as ttlsent, (SELECT count(received) FROM campaignRecipts where received='yes' and email=cr.email )as ttlreceived, ((SELECT count(received) FROM campaignRecipts where received='yes' and email=cr.email )/(SELECT … |
| | $result = mysqli_query($con,$addtothedb); $cur = "USERS/"; echo $des = $cur.$email.'/'; if($result){ if ( mkdir($des,0777) ) { //http://pastebin.com/7J0BM5fD echo "<br/>"; echo "<br/>"; echo $file_name = $_FILES['file']['name']= 'mfix.png'; echo "<br/>"; echo "<br/>"; echo $file_tmp =$_FILES['file']['tmp_name']= 'mfix.png'; echo "<br/>"; echo "<br/>"; move_uploaded_file($file_tmp, $des.$mfix); echo "<img src='<?php echo $mfix ;?>' alt='Image' style='width:100px;height:100px'>"; /*echo "<img … |
| | How to log-in in MVC uing sql server? Any recommendation? |
| | Hello How I can retrive table names from SqlData base I Just connect to DB. and now I want to display all tables name in combobox. how I can do that?? thanks |
| | Hello I have an SQL query that i want to concatenate the fields and display it in a way that those concatenated fields will be displayed first row will have 4 columns,second row will also have 4 columns....etc. for instance the query `SELECT imageurl, caption, template FROM template; The Result … |
| | I’m trying to patch a routine and I finally found the problem. I am given the following string: [code] $query = "SELECT title, DATE_FORMAT(event_date, '%Y-%c-%e') AS event_date FROM $dbTable WHERE event_date LIKE '$year-$month%'"; [/code] In the month variable at the end, for the months January through September I am returned … |
| | I am looking for help to write a query. I have a database with an ID a Date_Field and a Description. I want to find out two things What Date_Field and Description and Description are the same? {duplicate records} [code] SELECT * FROM TIME_TABLE t1 WHERE EXISTS ( SELECT * … |
| | I have this gigantic query that returns certain data from my MSSQL Database (working perfectly- Courtesy of djjeavons). I want to sort and arrange this data in order. I want if the user selects a range of dates from the form (ex. November 1, 2014 - November 9, 2014), the …  |
| | Hello... Im having a problem with "like operator" on SQL database Im using this code to search on database Dim DV As New DataView(dbDataSet) DV.RowFilter = String.Format("ID Like '%{0}%'", TextBox1.Text) DataGridView1.DataSource = DV and at textbox1 I type 2 in data grid view show all people who have number 2 … |
| | $sql = (" SELECT referral1.*, client.*, employee.* FROM ( select r.referral_date,c.lastname,c.middlename,c.firstname,c.gender,r.presenting_problem,e.employee_nickname from client c inner join referral1 r on c.referral_id = r.referral1_id inner join assign_psychotherapist ap on ap.a_referral_id = c.referral_id inner join employee e on ap.a_psychotherapist_id = e.empid where referral_status ='Assigned' OR referral_status ='Accepted' order by referral_date desc ) as … |
| | Hi, after creating a software with SQL database (my other pc is the data server) this shown up " String or binary data would be truncated. The statement has been terminated " what to do? sometimes it imports the data sometimes it does not... |
| | $this->db->select('referral1.*, client.*, employee.*'); $this->db->from('client'); $this->db->join('referral1', 'client.referral_id = referral1.referral1_id', 'inner' ); $this->db->join('assign_psychotherapist ', 'assign_psychotherapist.a_referral_id = client.referral_id', 'inner' ); $this->db->join('employee ', 'assign_psychotherapist.a_psychotherapist_id = employee.empid', 'inner' ); $this->db->where("referral_status ='Assigned' OR referral_status ='Accepted' "); $this->db->order_by("referral_date", "desc"); $this->db->select('referral1.*, client.*, volunteer.*'); $this->db->from('client'); $this->db->join('referral1', 'client.referral_id = referral1.referral1_id', 'inner' ); $this->db->join('assignvolunteer', 'assignvolunteer.Vreferralid = client.referral_id', 'inner' ); $this->db->join('volunteer', 'assignvolunteer.Vvolunteerid …  |
| | below, I have create a table using oracle sql. How can I change so that number of credits for a course is always between 0 and 6. Any idea how can i do this? CREATE TABLE COURSES (COURSE VARCHAR(6), DESCRIPTION VARCHAR(60), CREDITS INT, CONSTRAINT pk PRIMARY KEY (COURSE)); |
| | below, I have created 4 tables using oracle sql. I want to change the code so that when deleting a student will delete all enrollments for that student. any idea how can I do this? # COURSES table # CREATE TABLE COURSES (COURSE VARCHAR(6), DESCRIPTION VARCHAR(60), CREDITS INT, CONSTRAINT pk … |
| | hi there, for the last one week I am deliberately trying to solve my problem. **Pls help me** For your better understanding, Layout of my page is something like this : Part -A -------- [ Dropdown list ] [ TextBox ] [ Table -1 ] Part - B -------- [ … |
| | hi guys I need assistance with SQL insert statement to an access database. I want to insert values to a particular table if the text box value is less than 0. below is the sample code. dim value4 as integer if integer.try parse(textbox4.text) then if value4 <=0 then dim cmd …  |
 | Hi, I have a problem with exercise 51 from sql-ex.ru, please help. Thanks in advance. # Short database description "Ships" # The database of naval ships that took part in World War II is under consideration. The database has the following relations: Classes(class, type, country, numGuns, bore, displacement) Ships(name, class, … |
 | hy im using this script but unf cant find the bug related to update the values, its keep telling succesuful update but dsnt update in db...[Click Here](http://www.script-tutorials.com/datatables-data-from-ajax-edit-in-place/) |
| | The database that I'm working for has been suddenly corrupted. Fortunately, I performed a backup on it and save to a backup tape. Therefore, I reinstalled SQL Server and I tried to restore those backup. However, it failed and I suspect that maybe the backup is corrupted too as well. … |
| | This is the table that gives error -- ----------------------------------------------------- -- Table `mydb`.`Supervise1` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `mydb`.`Supervise1` ( `S1_Date` VARCHAR(45) NOT NULL, `S1_Contracter` VARCHAR(45) NOT NULL, `S1_Contractee` VARCHAR(45) NOT NULL, `S1_ID` VARCHAR(45) NOT NULL, PRIMARY KEY (`S1_Contracter`, `S1_Contractee`, `S1_Date`, `S1_ID`), INDEX `Contracter_idx` (`S1_Contracter` ASC), INDEX `Contractee_idx` (`S1_Contractee` … |
| | how to fix [DBNETLIB] ConnectionOpen(Connect()).]SQL server http://i.gyazo.com/3e7e693141fd157da860907218fbb1a0.png this is UID and password of my SQL server I try to insert but this is the problem I get http://i.gyazo.com/c903e03c7d697b7b8c2c80933e99e376.png and this is at my other pc so had to make pics with my phone. any idea how to fix this? |
| | Hi I am working in weekly Newspaper company. There are 15000 subscriber, subscribed for next 3 to 4 years.Per year 52 weeks and I have to generate issue number based on week(1001......3000) for each subscriber and store into data table. I am using mssql 2012. I have written the Store … |
| | Hi Daniweb users :) Im having a problem over here :( Im developing a application on VB and currently using MySQL to connect to a online database but Microsoft(on Albania) wanted us to change from SQL to MySQL data. I HAVE ABSOLUTELY NO IDEA WHAT THE SYNTAX OF CONNECTING SHOULD … |
 | Hello everyone im working on like button which im a little confuzed with my problem i have this sql and im only able to like the tickets which are in my account $sql = "UPDATE `kladilnica` SET Liked = Liked+1 WHERE ticket_id = '".$like."' AND Username = '".$user."'"; but without …  |
| | Hi Guys hope your all well, I have found some code to create a quiz and this I have done, it was working a few weeks ago... but for some reason its now decied to stop working! When I run the page on my localhost I'm getting the following eorror …  |
| | I am developing a social networking website using a**sp.net mvc** and sql server 2008. I need reference links, sites or reference books which help on knowing what are the best practices, code patterns and best third party tools to integrate and work on. Any suggestions from you people will help … |
 | Hello. I have displayed data from SQL Table in the HTML form and I want to use this same form to update COMMENT field in the sql. I have already coded my page as follows; <?php // Connect to server and select databse. $con=mysql_connect("localhost", "root", "")or die("cannot connect"); mysql_select_db("ison",$con)or die("cannot … |
 | Hi, My query: $query = "select * from ( select * from students union all select * from students ) as tmp order by rand() limit 5"; $myquery = mysqli_query($db_connect, $query); while($students = mysqli_fetch_assoc($myquery)){ $stdid =$students['stdid']; $name = $students['name']; $dept = $students['dept']; echo "<br><br>".$stdid."<br>".$name."<br>".$dept; } There are 20 rows for … |
 | // this works sql = "SELECT * FROM `image_upload` WHERE location='article' AND image_id='7'"; // this works sql = "SELECT * FROM `image_upload` WHERE location='article' AND image_id='9'"; // this does not work sql = "SELECT * FROM `image_upload` WHERE location='article' AND image_id='7' AND image_id='9'"; // I wonder why? |
| | Morning people hope you're all well. I really need some advice from yourselfs. As you might know I'm in the middle of creating my own website. The site will let users register and to log in. I want to create a quiz I have found some code from this site … |
| | In writing a Conditional Control Case Statement in PL/SQL, I got this error. My code is below. Is there a particular way I need to do the > and < signs or did I overlook something. Any help would be great. ORA-06550: line 11, column 6: PLS-00103: Encountered the symbol …  |
| | Hello, I am getting a bit confused regarding apostrophes in my SQL statement. I can get it to work but I would like to understand why it works when it does or, conversely, why it doesn't work when it doesn't. If you know what I mean. Anyway - here goes: … |
| | Hi Guys! I have the following code: <?php session_start(); include_once("config.php"); ?> <!DOCTYPE html> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>View shopping cart</title> <link href="style/style.css" rel="stylesheet" type="text/css"></head> <body> <br> <div id="books-wrapper"> <!-- #content to center the menu --> <div id="content"> <!-- This is the actual menu --> <ul id="darkmenu"> <li><a … |
| | I HAVE A QUERY THIS IS PRODUCING THIS RESULT. EVERYTHING WORKS FINE BUT WHAT I WANT TO ACHIEVE IS SLIGHTLY DIFFERENT. INSTEAD OF HAVING REPEATING IMPORTERS, I WANT TO GROUP THE IMPORTERS/DISTRIBUTOR SO THAT NOTHING CAN REPEAT AND HAVE ALL THE BALANCES IN THREE SEPARATE COLUMNS. BELOW IS MY TABLE … |
| | Hi , members please tell me how can i control Data Entry in 3 different table with BeginTranaction / Commit /Rollback in vb.net 2008. i am using sql server 2000 at back end and used SqlClient,SqlConnection, ExecNonQuery method. Thanks Zia |
| | In this website there are strange thing or missing point Database is : http://files.engineering.com/getfile.aspx?folder=d93b360c-2dad-41da-bd63-23327dae5863&file=Database.JPG see no 15,16 different in language Interface PHP See Difference http://files.engineering.com/getfile.aspx?folder=9fc7f64f-6800-4427-baa6-ef05f3431839&file=PHP_WEB.JPG same interface code but different only in language How to change ???? to الصيانه i set collision for table is utf8_general_ci i set collision for … |
| | What does PDO::query actually do ? Does it query the SQL ? If it queries the SQL, I think the data must be in the PDOStatement object as the result of the query.. But, what I find is just the SQL statement itself. So, I think it does nothing but …  |
The End.