2,569 Topics
 | |
| | I have a form that has two parameters amenities and attributes. The amenities parameter has a dropdown menu that whose value gets populated from a separate table. The second parameter is attribute whose value will be entered by the user and will get saved in a database. View of database …  |
| | After Designing database--->Connection to database--->Data entered-->Data stored in database.My doubt is in which format data is viewed on the screen.(XML OR EXCEL OR PDF) |
| | Hi there! I have a problem and i want you guys to help me. I have 1 table which has many fields. (mysql and im connected from microsoft visual studio..runs very well so there no problem with this). lets forget the fields that we dont want now.. i have 4 … |
| | I have an Access Database on which I have tables with similar structure and columns name columnA and columnB.I can use the below query on tables created design time to get this output. Table | result -------|-------- SELECT "Table1" AS Table, SUM(a) - SUM(b) AS Result FROM table1 UNION SELECT … |
 | Alright, so the following has stumpted me and a few others in the office, and we just can't figure it out. I have develope a program that allows us to go out to a specific database and search one of the fields based on specified values. Now that seems all … |
| | I'm trying to create a store procedure in mysql and it is giving me errors and I don't know why since the sql code works just find. Here is the sql code: CREATE TEMPORARY TABLE IF NOT EXISTS table2 AS ( select AVG(Score) as AVG, MovieCode from UserMovies group by … |
| | Hello everyone, I am putting together a project where people are able to upload multiple choice questions to a larger database and then create tests from them. I have several questions (and I apologize for the length of this post) about what is the best way to go about doing … |
| | Try DoInsertQuery("If Not Exists(" & _ "SELECT * FROM tblSchoolYear " & _ "WHERE schoolYear = 'SY " & Trim(txtAddSchoolFrom.Text) & "-" & Trim(txtAddSchoolTo.Text) & "')" & _ "INSERT into [tblSchoolYear] ([schoolYear]) VALUES ('SY " & Trim(txtAddSchoolFrom.Text) & "-" & Trim(txtAddSchoolTo.Text) & "')") Catch ex As Exception MsgBox(ex.Message) End Try … |
| | I'll prelude this with I am a novice coder at best and this is mostly a hobby that I would like to do professionally one day, but that day may be 10+ years from now. So for now I tinker and learn here and there. Part of the reason I … |
 | Hi, I need to compare record using sql ce I have this data, can be thousand rows ID Type Date Time 02-0009 I 01/02/2014 8:00 02-0009 O 01/02/2014 18:00 02-0009 O 01/03/2014 18:00 02-0009 I 01/04/2014 8:00 02-0009 O 01/04/2014 18:00 For every date there should be a 'I' and … |
 | I'm using MS SQL 2012 - trying to LEFT JOIN 3 Pivots - but am running into issues within a query variable that I'm not sure how to debug. Each Pivot works on it's own - but the actual Joining is causing the issue. Any help is appreciated. First time … |
| | the relation betwwen student and course entity is many to many.but it is not recommended .how can we convert it to two one to many relationships?  |
 | 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 … |
| | 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 …  |
| | |
 | 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 … |
 | Hi, > I want to know how to store and retrieve picture path from sql server. Can anyone show me the code please. |
| | 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 … |
| | 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 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 / … |
| | ** 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 …  |
 | 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 …  |
| | 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 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, 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, 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 … |
| | Hi, I need to retrieve only 1 row for each 'message_id', with the Latest Date('sent_date'): ------------------------------------- message_id | sent_date | ------------------------------------- 805 | 2010-08-04 17:48:24 | <--- 805 | 2010-08-03 17:48:24 | 1007 | 2010-08-07 17:48:24 | 1007 | 2010-08-09 17:48:24 | <--- 1007 | 2010-08-08 17:48:24 | ------------------------------------- The … |
| | I have read from different forums, PHP website and Microsoft website how to connect PHP to MS SQL Server but the provided solutions didn't worked for me. If you could help me in this would be greatly appreciated. |
 | I have following tables for photo album script. How to display Album title and album cover inside anchor tag? (Display Albums cover on homepage and redirect to gallery page, when clicked, to see images inside that album) * get id of album * get album title * get album cover … |
| | Hi Ive been using my sql server lately but for this past few days, its been crashing. I'm trying to find solution but seems nothing works or I'm just doing it wrong. Its sql server 2008 R2 Error details: Problem signature: Problem Event Name: BEX Application Name: Ssms.exe Application Version: …  |
| | Hi guys. I wanted to create a quiz for my website. I have found some code from a website called (getcode.org) (prev world of webcraft). The quiz now works as it should and I'm very happy it does. There is one problem I have adapited it to the needs of … |
 | I'm using: Windows 7 Home Premium 64-bit operating system Netbeans IDE 8.0 WAMP Server 2.5 Here is my issiue. I am attempting to follow the E-commerce tutorial in the Netbeans Java EE & Java Web learning trail (Section 3 "The NetBeans E-commerce Tutorial - Setting up the Development Environment"). In … |
| | I am trying to insert records in a SQL table from Excel sheet with VBA code. Data contains of a range with all the rows to be inserted. I am using below code for the same. Insert INTO [odbc;Driver={SQL Server};Server=myserver;Database=mydb;Uid=abc;PWD=abc].DPR Select * FROM [TempRange] I am getting error as above. …  |
| | This should be an easy question. I just need to make so that when you click on some function in pgAdmin 3 and then click the SQL button on the top (the focus glass icon) the code form the selected function (showing in the sql pane) to automatically show in … |
| | I want to import/upload excel files to sql server via cake php, it will occur Undefined variable: ext and Undefined index: the code are shown as below. Is there any mistake in my code? Thanks in advance! <?php App::import('Vendor', 'php-excel-reader/excel_reader2'); class UploadsController extends RealTimeAnalysisAppController { public function upload() { $destination …  |
| | I need help trying to get my mysqli_query() function to work right. I have this so far: $raw_results = mysqli_query($con, "SELECT * FROM numdata WHERE numb='%".$k."%' UNION SELECT * FROM numdata2 WHERE numb='%".$k."%' UNION SELECT * FROM numdata3 WHERE numb='%".$k."%' UNION SELECT * FROM numdata4 WHERE numb='%".$k."%' UNION SELECT * … |
| | I have vb.net application with SQL server express. Here is my code to save data to database, but itn not working. Here ID is not the primary key. Imports System.Data.SqlClient Imports System.Data Private Sub btnSave_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSave.Click Dim cmd As New SqlCommand Dim … |
| | Whats wrong with this query? For example $brand holds the value 'apple' Then I get the error 'unknown column 'apple' Can anyone see the problem? if(isset($_GET['brand']) ? $_GET['brand'] : 0){ $brand = (isset($_GET['brand']) ? $_GET['brand'] : 0); $sql = mysqli_query($link, "SELECT COUNT(id) FROM products WHERE brand = $brand AND status … |
| | i'm not sure what is the syntax error. I try in this source code in dreamweaver, it shows line 8 is a syntax error. $destination = realpath(‘../../app/webroot/uploads/excel/’); App::import(‘Vendor’, ‘php-excel-reader/excel_reader2’); //import statement class UploadsController extends RealTimeAnalysisAppController public function upload() { $destination = realpath(‘../../app/webroot/uploads/excel/’); //Set your upload path here if(isset($_FILES['Upload']['XLS_File'])); $ext = … |
| | Hi i am trying to display records in access database that have pictures saves binary data i have created typed dataset that populate the crystal report but the problem is the images do not display code is as below i have attached sample report Imports System.Data Imports System.Configuration Imports System.Data.OleDb …  |
 | -->>Hello,My problem is how will a trigger a php Function based up on Change event of a listbox value. My Page has the Field as those in the screenshot below the code: So when a driver is selected on the list all his/her details should be populated in the remaining … |
| | i tried to mimic the code of a tutorial for a live updatable table....dat is connected to the MYSQL server .... i copied it and edited it a bit...but its not working... i was not able to understand the code so dont knw where the problem is here is the … |
 | hi all! it might look similar to previous question but actually different.. i'm trying to calculate stock value. for this i want to use "average last purchase value" of item. like if closing stock is 14 and purchase detail is like this 2014/2/2 15pc @ 38000 2014/2/15 5pc @ 36000 … |
 | In true Microsoft fashion they have made the download process so counterintuitive that your chances of getting what you want is near impossible. Fortunately someone has created a "simple" [12 step process](http://www.istartedsomething.com/20140616/the-12-step-process-to-download-microsoft-sql-server-express-2014/). For yuks, see also [here](http://www.istartedsomething.com/20121216/downloading-sql-express-2012-from-microsoft-com/). And to see how little things have improved see [Bill Gates Chews Out … |
| | This code was to create a simple database with a table and add records with the following. toIm having trouble with the 'id' auto_increment. <?php $con=mysqli_connect("localhost","root","distortion","my_databs"); // Check connection if (mysqli_connect_errno()) { echo "Failed to connect to MySQL: " . mysqli_connect_error(); } // Create table $sql="CREATE TABLE empl(ID INT NOT … |
| | Hi, I want to display the department no. and the no. of employee in each department from EMP Table.(in a Single Row). Pls help me how to write the query for that. I had one query which display the result in 3 rows. select deptno, count(*) from emp group by … |
The End.