Member Avatar
Dear devolepers, I have problem with my sql database, I want acces my sql database in my <LI> list plaese help to resolve this problem Here is my html sql database : my_db table : info_list Table columns : id,name,job,town,mobile1,mobile2,phone,adress i want to display town list in this <li> list …
by Faisal_13 in Web Development ()
Member Avatar
I am banging my head again, and appologise if such a qestion has been posted and answered - i searched and could not see any results matching my question. I have a datagridview1 full of data, one column has a date and another a qty. datagridview1 Date Qty 2015-11-05 | …
by Oxley_1 in Databases ()
Member Avatar
Customers pick When finished If on the book, such as the selection of Van Dyke VT01 from 1/07/59 - 2/07/59-day period, you will not be able to book your car again. It is based on the availability of the vehicle. I made a separate table Storage booking Van table separately …
by Goddy_1 in Web Development ()
Member Avatar
Hi group, I've looked all over the internet to find my solution without luck. Hopefully you can help. I need to add an Oracle server to my data sources in Visual Studio (if it matters, I'm using VB.net). Per the best instructions I've found so far, I've selected "Data Sources" …
by doncwilson_1 16 in Databases ()
Member Avatar
sir can you help us or give us an idea in our System Tutorial (Thesis) in our subjet Software Enginieering, our professor required us to make a system that is not yet existed, Examples Grading system, Inventory System, Using VIsual basic 10 with the connection of data base, . sir …
by _1_36 in Databases ()
Member Avatar
I am working on projects in Visual Studio 2015 using the ASP.Net Identity with Entity framework. Entity Framework creates tables in embedded SQL Compact, when the first user is created. My question is: When comes time to roll out into a "live" environment (i.e. Dev, Test or Prod), is there …
by Greg_10 in Web Development ()
Member Avatar
How to retrieve data from another database using PHP, mySQL?
by AntonyRayan 15 in Web Development ()
Member Avatar
Hello everybody, so, I realized that when I try to load some XML into a MySQL table through the `LOAD XML LOCAL INFILE ...` statement, if there is a parent with the same name of the child, MySQL will insert an extra row. Here's the example to reproduce the issue: …
by cereal 1,078 in Databases ()
Member Avatar
Hello, I almost forget. Last time someone recommend me a software that I could use repeatedly for sql database management that real web developer must have in exchange of the free one like xampp that often shows error. Can anyone help me fix this error? Thanks in advance, Davy
by davy_yg 16 in Web Development ()
Member Avatar
Hi Guys, I'm new to vb.net programming. I'm finding it really hard printing selected columns in a datagridview. there are 12 columns and i would like to print just a few in a landscape view. Please, can someone help me.
by Daniel_57 in Databases ()
Member Avatar
$stmt = $dbconn->prepare("SELECT * FROM `members` WHERE username=? AND password=?"); $stmt->bind_param("ss", $username, $password); Is what I have. Database is connected etc. How can I set variable called `$dbresult` with array of SQL result? I don't want to set individual variables. I really need an entire array as answer. There's couple …
by Aeonix 39 in Web Development ()
Member Avatar
i want to combine multiple rows into a single row using **DB2**. I have found this code, but I do not know how can i edit it>? CREATE FUNCTION MySchema/MyUDF ( PARCol2 CHAR(5) ) RETURNS VARCHAR(1024) LANGUAGE SQL NOT DETERMINISTIC READS SQL DATA CALLED ON NULL INPUT DISALLOW PARALLEL BEGIN …
by xuexue 15 in Databases ()
Member Avatar
I'm sure I've mentioned this type of wrapper class for accessing databases in a provider-agnostic manner before, but never posted a functional implementation. So here it is. Questions, comments, and suggestions are welcome as always. :)
by deceptikon 1,711 in Software Development ()
Member Avatar
Hey new to JDBC SQL DERBY and Java so I don't know why but my Jtable only shows the columns. Here are my codes for my LeaderboardDAO class. public class LeaderboardDAO extends Dao { private static final Logger LOG = LogManager.getLogger(PlayerDAO.class); public static final String TABLE_NAME = "leaderboard"; private static …
by Ronnie_2 in Software Development ()
Member Avatar
I have a large database of information of characters This contains "owner", "charactername" & a lot more info the owner can easily repeat as they own more then one character. what I'm trying to attempt to figure out how to do is create a list of UNIQUE names and how …
by wikit 13 in Web Development ()
Member Avatar
Hi Guys, I need your help to create query dynamically, how to populate data value from formula in other table. Sample Below Table A ID Amount 1 50 2 40 3 50 Table B ID FormulaID VALUE X 1+2+3 Y 1-2+3 Result Expectation ID FormulaID VALUE X 1+2+3 140 Y …
by ilvanhellovan in Databases ()
Member Avatar
Hi .. I have been asked to create a new thread rather than recurrent on old post ([url]http://www.daniweb.com/forums/thread116468-2.html[/url]), hope to get some help here... :) I would like to have a "Extract" button which then open a Save As dialog to save the file from the Database into local pc, …
by eURe in Software Development ()
Member Avatar
Good day I have a table which I have already uploaded a list on however I want to return all the records which are duplicated and have a year between 2014 and 2015, i.e if I have a table like this Year IDNumber FirstName Surname Email 2014 8809254 Tom Jackson …
by kgizo in Databases ()
Member Avatar
I have the following code is asp.net <%@ Page Title="" Language="C#" MasterPageFile="~/Site02.Master" AutoEventWireup="true" CodeBehind="Tasks.aspx.cs" Inherits="DMS.Tasks" %> <%@ Register assembly="Telerik.Web.UI" namespace="Telerik.Web.UI" tagprefix="telerik" %> <asp:Content ID="Content1" ContentPlaceHolderID="MainContent" runat="server"> <telerik:RadAjaxPanel ID="RadAjaxPanel1" runat="server"> <div class="row-fluid sortable"> <div class="box span5"> <div class="priority high"><span>Assigned By Me</span></div> <div class="task high" runat="server" id="Task01"> <div class="desc"> <div class="title">Test 45</div> …
by naheedkassam in Web Development ()
Member Avatar
sorry for this silly question, i would like to learn ORACLE but i dont know from where should i start and what toopics should be covered? i know sql.so i like to start pl/sql. please suggest me what topics should i cover?
by sukumar paul in Databases ()
Member Avatar
Hey everyone, I have a question about a database design that I have right now. The template I was given from someone is the first attached that you will see. I looked at it and figured that the database design of that is not the best, so I decided to …
by TheFearful in Databases ()
Member Avatar
Hi! I have two tables. Table 1 - fields are: no, referenceno, date, marine Table 2 - fields are: no, referenceno, controlno, date What I would like to do is to retrieve the field **controlno** from table 2 when field **marine** in table 1 = "Y". Coding: SELECT NO, REFERENCENO, …
by xuexue 15 in Databases ()
Member Avatar
I know this is very basic but i am not able to get the fuction return a string. Instead it is returning the value 1. Below is the code: <?php function getUserRole($username, $roleid){ include "data.php"; $con=dbConnect(); $query="select * from user inner join userrole on user.id = userrole.userid inner join role …
by Amaina in Web Development ()
Member Avatar
Hi! I am doing a system in Visual Basic .NET. My vision is to have different users, with their own PCs, using the same database. Which database should I use to have this feature: local or service-based database?
by CodingSource in Software Development ()
Member Avatar
Hi I am trying to do the same thing. I would like to save the Facebook user timeline details OR messages in MySQL database. Timeline details are visible in screen total posts are like this http://screenshot.co/#!/2dcbee03ff , if I want to see the 'messages' only I can see in the …
by anupamjamatia in Web Development ()
Member Avatar
Sorry i dont know how to explain this properly, but what i'm trying to get across is how do i get sql to select a data type (i dont think thats wording it properly, sorry) which only appears once? Thanks ;p
by pleasehelplmao in Databases ()
Member Avatar
I am trying to create a table in html/php that is dynamic sized but allows users to edit rows of the table, I have 99% of this done and the last piece is to send edited values VIA ajax to an edit page where I update to the database and …
by toxicandy 2 in Web Development ()
Member Avatar
I'm in a Java class we are using netbeans to create a program. I have the code in and it builds but it will not run. Can anyone assist
by lo022 in Databases ()
Member Avatar
Connection is successful. No typo's were made (look below). If read it from top to bottom, some of the tests that I show you will seem stupid. Until you look at the end (still keep reading from top to bottom) and find out that it's one of the indicators. SQL …
by Aeonix 39 in Web Development ()
Member Avatar
I have a database in mysql which contains of four tables (Student, Units, Offering and Enrols_in) and i want to create an enrolment page where students can enrol in units which will be offered in each semester. Student names will be entered in the database and they will use their …
by naithsleeray in Databases ()