6,934 Topics
 | |
| | I like to join the 3 tables in without using joing query is possible... |
 | Hello :) I'm trying to create web application. I followed the tutorial given in this site : http://aspsnippets.c...-in-ASPNet.aspx My problem now, after I create a table and the UI. Next step show about stored procedure. What is stored procedure use for? Do I need this even though I had a … |
 | Hi, thanks for any help in advance. I was hoping to get some guidance for getting started with connecting to an SQL database online. I'm writing an application in Win32 which needs to be able to read/write to a database. I have plenty of experience with C++, but almost no … |
| | Morning guys hope your well, at the moment I'm creating a regsiter and log in page for my website. When I load the page on my local host, the page does not show and all that does show is my nav bar. Can anyone give me a hint as to … |
| | Hello all ! Good evening :) I'm a newbie on learning about .NET framework. I want to ask, if anyone can help by to show or guide me how to create a simple web application using VB.NET language and also involve a database part. In other word, I want to … |
 | **Hey Daniweb!** A bunch of us have been putting together a web-based drawing app. In a nutshell, users connect in real-time to draw or chat on a sort of interactive whiteboard. Plenty of these are made in Flash, but we are determined to build it in JavaScript and HTML5; a … |
| | Hi guys, I want to multiply or add the values of two or more cells in a datagridview control in a row and and should also be auto-saved in the database after entering datas in the cell. I am using SQL Server 2008 for my database. Please do take a …  |
| | Hi I need to look in a field to find the text same as another field I have this at the moment but it does not work, hoep you can help update TAB1, TAB2 set `field3` =`field4` where FIND_IN_SET('`FIELD1`', '`FIELD2`') I feel FIND_IN_SET is not the right thing as the … |
 | Does anyone know this error : Syntax error (missing operator) in query expression '***Budy Soleman***' **<--( this is content of textbox.text)** This is my code in VB.net with ms-access Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Call connect() Dim simpan As String simpan = "insert … |
 | Hi, I want to output a simple result. I join 2 tables and SUM one column in one, i get the SUM results correct but cannot get the num_rows proper. My Code: $clientid = 24; $query = "SELECT items.itemid, SUM(prices.priceid) as PR FROM items JOIN prices ON items.itemid = prices.itemid …  |
 | Hi guys Im trying to save a combobox selected item to my database but i cant get it working, it saves "user" instead of the username that is stored in the combobox, any suggestions? here's a snippett Try '----------------Sends the message------------------------------------------------------------------- MysqlConn.Open() ' opening the connection to the DB Dim … |
| | I have the following view: ALTER VIEW [dbo].[vw_RelInclusaoGeralCivil] AS SELECT DISTINCT m.Nome AS MunicipioNome, au.Nome UsuarioNome, s.TipoId AS SolicitacaoTipoId FROM Solicitacao s INNER JOIN Unidade u ON s.UnidadeEntregaId = u.Id INNER JOIN Endereco e ON u.EnderecoId = e.Id INNER JOIN [IBGE.Municipio] m ON e.CodMunicipio = m.CodMunicipio INNER JOIN Terminal t … |
| | |
 | I worked on a program a few years ago that takes data from a series of text files and loads an Access database. I added to the code from a program started by someone else, so I did not write the imports and declarations. They used an ADODB.recordset, addnew and … |
 | Split pipe delimited into new columns as below : col1 col2 col3 col4 Data|7-8|5 Data 7-8 5 Data|asdsad|sad Data asdsad sad fish|c cx cx xc cc xc cx |ededededeed fish c cx cx xc cc xc cx ededededeed Data|iueroiheqroqer|ewoijewijewd5 Data iueroiheqroqer ewoijewijewd5 tune||5 tune 5 Data|| Data check http://stackoverflow.com/questions/19688863/split-pipe-delimited-into-new-columns  |
| | I am working on a small project, creating a calendar based booking system which includes the following features: 1) A color coded key for Booked days, Available, Partly Booked, Off Days 2) Clickable days which open up a form with available time slots 3) When time slots selected another form … |
| | Hi, I have a filestream enabled DB and a table to store the files. Until now i used to get the path of the file that has to be saved to DB. But due to some changes this was changed and now i get a byte array. my question here … |
| | I'm getting the following error when I add the product through Admin panel You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''1,'' )' at line 1 |
| | What is difference between MySQl & MSSQL database storage limitation. More descriptively, If I make databases using the above-mentioned database systems. How much data I can store in each of them, i.e. 1GB, 2GB, 10GB, 100Gb. What is the limitation? |
 | Hello: Before I post code I will say that last year I hired a programmer to build one feature for my project. Today upon further inspection of the database/tables I am receiving errors that I have never received and I am at a loss as to their actual meaning. I … |
| | How can I List 15 longest words and their lengths in a table.  |
 | Hi, I originally created this query to get a result from a single select statement Its funny that it became a very long query having sets of joined table Its also maybe annoying to look for it so im trying to trim it down most of it have same joined … |
| | Hello, I have written the basic shell script "myscript.sh", which prints Hello World. I want to call this script using PL/SQL. Please let me know the procedure(steps) for the same. Thank you. |
| | I know that myisam is no longer used by I don't know how to update the query. I am trying to create tables with text in "Run SQL query in myphpadmin. Can anyone help? This is the complete error I receive: //MySQL said: Documentation #1064 - You have an error … |
 | Hi 01 - i have create an sql function in my database that take to Date params with code: CREATE FUNCTION [dbo].[SelectEmployee](@frm_date DATE, @to_date DATE) RETURNS TABLE AS RETURN SELECT Emplo_ID, Emplo_Name, Work_Date FROM Employee_Data WHERE Work_Date BETWEEN @frm_date AND @to_date GO 02 - after that add it to project … |
| | Hi insert command works update does not do anything any help Please SqlTimes.InsertCommand = "insert into athletedata([Athlete],[Mydate],[session],[mytime]) values ('" & athletename & "','" & storedate & "','" & todaysession1 & "','" & savetim1 & "') " SqlTimes.Insert() SqlTimes.UpdateCommand = "UPDATE Members SET [Agegrade]=('" & savetim1 & "'where [Fullname]='" & athletename … |
 | Hello guys i have a big problem over here and and wierd i think, when im trying to add some info into database it works well i have 32 input fields (16 for matches and 16 for match tips) and when i will enter in each some info for ex. … |
| | Hello I have a project where I have 2 textboxes called "Name program" and "Error" where I have to write data in, Once I have wrote the data I have to import these 2 textboxes into an SQL database so it has to show like this in the database: Name … |
 | Hi everybody. I'm using python to create sql database. I created a test.db file and then made a table on it with the name "fims" and inserted some data on it.... title text, year text and director text. And then set values for them. Now when i type "sqlite3 test.db" …  |
| | I have a little problem over here this code doesn't work well what is the problem if anyone know ? $getUsername = getUserData('Username'); $sql = "INSERT INTO `kladilnica` VALUES ('', '".$getUsername."', '".$betAmouth."', '".$gain."', '".$date."', '".$match1."', '".$match2."', '".$match3."', '".$match4."', '".$match5."', '".$match6."', '".$match7."', '".$match8."', '".$match9."', '".$match10."', '".$match11."', '".$match12."', '".$match13."', '".$match14."', '".$match15."', '".$match16."', …  |
 | Hi, I run into an interesting thing. I'm looking into SQL a bit, and was reading some tutorial on W3C, so I built a small application to play with SQL queries: inserting info in a table and then retrieve it as it is, filter it etc. The table contains 5 … |
| | Hi guys, I'm in a bit of a situation here and I was wondering if anybody has any suggestion. Basically, I need to retrieve some data from 2 or perhaps 1 SQL table (that's what I'd like you to help me finding out). OK, here are my two tables (sure … |
| | Hello i have this code and something isn't working but i dont know what, the code it does not updating the database at all and i don't get any errors. <?php if(isset($_POST['howMuch']) && isset($_POST['where'])) { $howMuch = $_POST['howMuch']; $where = $_POST['where']; if(!empty($howMuch) && !empty($where)) { $user_mBalance = getUserData('payCheck'); if($howMuch > … |
| | I am trying to come up with a query to track a student cohort based on their start term. I want to see if the number of students that started in 2012 actually go down in 4 years time. For this example I am starting with fall 2012 (12/FA). I … |
| | Hi Guys, Im a bit puzzled on the best way to store data which will later be saved to a csv. I am doing a record search on a database table which will get cycle through each employee and get the relevent information. Once I have done this I will …  |
| | Ok so i have been trying and trying to solve this issue, but to no avail. Therefore, i am posting here. Please note that i am a self learner and don't really know things in depth, just trying to learn.. So please be gentle. Here is my aspx code: <div … |
| | Hi, I have some experience in c# and would like to get more experience of C# with sql, because alot of jobs look for databases. Can anyone me recommend any good books or online tutorials for begineers. Thanks alot, |
| | CREATE TABLE cash_dtL ( Cash_id varchar(12) NOT NULL, Dateof date NOT NULL, Cash_in_hand number(8) NOT NULL, Cash_in_bank number(8) NOT NULL, Sy_dr number(8) NOT NULL, Property number(8) NOT NULL, FD number(8) NOT NULL, PRIMARY KEY (Cash_id) ); INSERT INTO cash_dtL values('001', '01-JAN-15', 1000, 12000, 1200, 0, 1200); INSERT INTO cash_dtL values('002', …  |
| | $sql = "select u.Id, u.username, u.email, (NOW()-u.authenticationTime) as authenticateTimeDifference, u.IP, f.providerId, f.requestId, f.status, u.port from friends f left join users u on u.Id = if ( f.providerId = ".$userId.", f.requestId, f.providerId ) where (f.providerId = ".$userId." and f.status=".USER_APPROVED.") or f.requestId = ".$userId." ORDER BY u.username ASC"; I don´t understand the …  |
| | Hello, I have been trying to write a procedure that should select the user ID and display their names. Below is the code that I have written, however, when I try to compile it, there are errors. Please someone help me as to where I'm going wrong with this code. … |
| | Unable to execute the sql query, only dispaying blank page. <?php require('fpdf.php'); $today=date('d_m_Y'); $hostname = "localhost"; $database = "developer"; $username = "root"; $password = ""; $conn = mysql_connect($hostname, $username, $password) or die(mysql_error()); mysql_select_db($database, $conn); class PDF_result extends FPDF { function __construct ($orientation = 'P', $unit = 'pt', $format = 'Letter', … |
| | hi, I'm using Windows7, My laptop is better in speed and working process when i install sql server2008 my system becomes very slow how can i recover this problem i need my system should be faster and also i need sql server,,. Please help me Thanks in advance  |
| | Hello, I'm building an expenses application in asp.net and I'm attempting to insert some data in a SQL database in visul studio but I get the following error (screenshot here http://s13.postimg.org/4kjmn4nev/SQL_error.jpg): The INSERT statement conflicted with the FOREIGN KEY constraint "FK_expenses_ToexpenseCode". The conflict occurred in database "Applications", table "dbo.expenseCode", column … |
 | hy, i'm having a big problem, thats because i'm new in this, i have two qrys unfort doesnt work if(isset($_GET['id'])){ $id=$_GET['id']; $qry=mysql_query("SELECT *,replace(category, ',', ' ') as category FROM articles WHERE id='$id'", $con); $sql = mysql_query("select *,Total17,sum(q5) Total18,sum(aste3) Total19 from articles where category= how ?",$con); if(!$qry){die("Query Failed: ". mysql_error()); } …  |
 | I have problems with the enable/disable of textboxes if the radio button is selected/deselected. Normally, if I select "Others" from the radio button group "Project List", the textbox is enabled. But if I select other than "Others", the textbox is not disabled. This also happens on the radio button groups … |
 | what is the best way to save data from multiple checkboxes ?? if i have 50 , 60 checkboxes Is it reasonable to set up a column of 50 or 60 checkboxes for ٍsaving value for each question separately ? and presumably there are questions that have not responded what …  |
| | In my Windows Forms c# project I try to connect to an already existing ms sql database file (added binding Source on the form, then : bindingSource -> properties -> DataSource -> add source - > .... ) but when I pick this file it writes something like "You dont … |
 | Hi Guys Please have a look at my model and then read below public function get_events(){ $query = $this->db->get('events',1, 1); return $query->result_array(); Okay so when i run the page i only get my message that no entry's are in the table! So when i insert a entry it displays the … |
 | please help me to do Saving Gridview and Non Gridview data to Sql Database  |
| | I have the following table User in my database Name(Varchar) DateOfBirth(datetime) Age(int) Name(Varchar) | DateOfBirth(datetime) | Age(int) John | 2014-12-20 23:59:59 | 0 Mary | 2014-12-20 23:59:59 | 1 How can i verify throught javascript if the field DateOfBirth of the table User of the database z is of type … |
The End.