2,403 Solved Topics
Remove Filter  | |
| | Good day, I've created a webpage on localhost using php. I have a local network with 3 computers at home. I can access the webpage only from one computer (http://localhost/mywebpage/). What changes should I make in phpmyadmin to be able to access the webpage from all computers? Is it possible? … Databases client-server mysql php  |
| | HI All, I'm writing an application in Visual Basic .NET but the application will use a SQL backend. If the user runs the application and the backend database is not set up, I want the user to select a SQL Database Instance, supply an administrator user ID (sa) and Password … Databases mssql visual-basic |
 | Hello I have a table item1 | Item | Qnty | ProdSched | | a | 1 | 1 | | b | 2 | 1 | | c | 3 | 1 | | a | 4 | 2 | | b | 5 | 2 | | c … |
 | Hello I am using Apache derby embedded database: I have been using a system to display records from the database described in "DisplayInstructorAvailableNowJTable.java". it allows the result set to create a model from a prepared statement. I have only uncovered the tip of the iceberg concerning JTABLE. I am not … Databases apache java java-swing open-source sql |
| | hi Folks, I haven't used access in a very long time, so i'm a little behind the 8 ball with it. I've got a date selection form (frmWhatDates) with txt boxes txtStartDate and txtEndDate. I want to send those values to report rptAccuracy rptAccuracy pulls from query qry_report_totals_sorted (which just … Databases |
| | Hey everyone, I have the following two queries, and want to know why the first one would return a count of 52, but the second would return a count of 51 when technically they should be the same; SELECT count(*) from Inquiry Inner Join NoDecision on Inquiry.ID = NoDecision.InquiryID_fk Inner … Databases mssql |
 | i created database in mysql along with 3 tables but when i opened C:\ProgramData\MySQL\MySQL Server 5.5\data then i found on .frm files and a single .opt file so where is my originalo datbase and data ? my datbase name is kustkht Databases mysql |
| | i have tblStudents and tblDepartments, so which keys a weak entity (student_department) would have ? studentid and departmentid ? is it so ? and both foreign keys will work as a composite primary keys ? is it ? Databases mysql |
| | is it possible to run mysql and ms sql at one pc ? mean local host ? |
| | i have a table for cities and data which has entries in LACS , now i want to copy that table from one database to another, is it possibe ? i googled but couldn't find reliable solution mean i have fear to loss data .s o anybody , plz suggest … Databases mssql |
| | when i use sha 512 on password field then it says k pasword field cannot be empty but when i remove sha512 constraint then it works and with any other hash it also works why ? and plz suggest me some good secrity hash etc to apply on password field Databases client-server mssql sql |
| | Hi I have a question, I want to transfer all nodes to a datarow Here is my XML <Employee> <person> <firstName>Jon</firstName> <lastName>Johnson</lastName> <skills>Singing</skills> <skills>Dancing</skills> </person> </Employee> THE HEADER TABLE SHOULD LOOK LIKE THIS WITH RELATION Profile_ID | Firstname | Lastname| 10 | Jon | Johnson | AND THE DETAIL TABLE … |
| | Hi, I have a dynamically generated sql query that is generated in VB6 and then passed on to SQL Server 2005. The query joins(inner join, left join, etc.) multiple tables. If I were to execute that query in Sql Server Management Studio, I would get something like this: TrayID| TrayID … |
| | hello I m 3rd year enginnering student in computer science field. I have to make project in DBMS using connectictivty with VB. could you plz suggest me the topics and guide me with ur valuable ideas. thanx Arpita Asthana Databases oracle |
 | Hi All , I need to get multiple result from same table my table structure is id category parentid 1 dress 0 2 men 1 3 mtshirt 2 4 women 1 5 wtshirt 4 If I give wtshirt it should produe result as wtshirt-men-derss how can I write query for … Databases mysql |
| | i have this page in hard form and i need to make a table for it in DataBase (Sql Serber 2008), i tried alot but couldn't find any way to make table for it in data base. + i have also user table in DB, so userid should b also … Databases client-server sql |
| | I have a small database of about 30 names that are all unique. The variable $member equals "Ann" but will change depending on the person to search for. I need to be able to return the exact match of the person's first name. I have tried many combinations of the … Databases mysql |
| | Hello all. I have a simple quoting system I am developing for a project, and need help with how to query rates. There are two tables, one for zips (with state, county, zip code, and a zip lookup code associated with each zip), and one for rate data (company name, … Databases mssql  |
 | Hi I have created many tables in database. Now when i used to create new table that's name may already exists. So, before creating new table i must know which table names are already exists in my database. And for that i want to display all the tables created in … |
 | Hi there, I've lost my password and username and am trying to log in using sysdba. It doesn't log me in and I would like to retrieve my username and password without re-installing the software. IS there a way of doing that?> |
| | Good afternoon. I am trying to import a csv file to a SQL database hosted through GoDaddy. However, I continue to receive an error which states "Line 7 has 24 values (20 expected)". Line 7 in my .csv file only has 20 columns (20 values) and no matter what I … |
| | Hello, I've recently accomplished an ASP.NET web application which allow their users to access some data in a database, but what I'm afraid of is conflict between these processes like if they were accessing same record in a database do i need to check changes in the record I'm updating … Databases |
 | i have writeen following query in my code. $tquery="SELECT questions.id,questions.date,questions.title,users.user_name,subjects.subject FROM questions INNER JOIN users ON questions.student_id=users.id INNER JOIN topics ON questions.topic_id=topics.id INNER JOIN subjects ON topics.subject_id=subjects.id WHERE subjects.id=".$_SESSION['sub1']." OR subjects.id=".$_SESSION['sub2'].";"; but when i am trying to echoing its result it is not displaying anything. |
| | Hi everyone, I'm sure the update statement is well-written but for some reason Oracle sql command line is refusing to execute it. UPDATE myTable SET country = 'Aus' WHERE username = '"martin"'; // I know you can see single quote and double-quote as well. Well, names were inserted into the … Databases oracle |
| | I have the following code in my **PHP** program: $query = "SELECT * FROM board_members"; $result = mysql_query($query) or die(mysql_error()); $data = array(); // create a variable to hold the information while (($row = mysql_fetch_array($result, MYSQL_ASSOC)) !== false){ $data[] = $row; // add the row in to the results (data) … Databases mysql |
| | I have located a potential issue in the correlation between 2 tables and would like to correct it before it actually becomes one. (actually I need to fix it so the new scripting I'm doing will work correctly) I have a member information table called 'members' (38,881 records) I have … Databases mysql |
| | mysql Inner join problem I have written a mysql query- SELECT questions.id,questions.date,questions.title,users.user_name,subjects.subject FROM questions INNER JOIN topics ON questions.topic_id=topics.id INNER JOIN subjects topics.subject_id=subjects.id INNER JOIN users ON subjects.id=users.sub1 OR subjects.id=users.sub2 WHERE users.id=8; which is giving error- 1066 - Not unique table/alias: 'topics' .i am unable to understand the problem. Databases mysql |
 | I have a a table with the following data: reservno || icode || location 00004 || 00021 || Bohol - Cebu 00004 || 00022 || Cebu - Manila 00004 || 00014 || Manila - Bohol I use this query to retrieve the concatenated value of location. `SELECT GROUP_CONCAT(location) from location_list … Databases mysql |
| | Hey everyone, I am looking to write a query that I think can be solved a nested select but I am not yet that fluent in MySQL to be able to get the query working correctly. Basically what I want to do is this; SELECT count(*) from Inquiry Inner Join … Databases client-server mysql sql  |
| | I have a database table like the one mentioned below. id | lecture | subject_id | date | is_deleted ------|--------------------|------------|------------|----------- 1 | Introduction | 1 | 2012-08-10 | 0 2 | Structure | 2 | 2012-08-15 | 1 3 | Introduction | 2 | 2012-08-12 | 0 4 | Functions … Databases data-structure mysql |
| | Hi there! I'm new to MySQL. What security measures should I take to ensure security of my databases? Any keywords? For instance, often times when logging into the DB, you must enter the user and pwd to gain access. How can I make that more secure? It's obviously in plain … Databases mysql |
| | Hi there, i need to draw an ERD Diagram and i can only draw the, product,blueprint,hardware,software and i am stuck Please help...i would appreciate it a lot.Many thanks. **Scenario:** You have been asked to create a database design for the BoingX Aircraft Company (BAC), which has two products: TRX-5A and … Databases database-design engineering mysql |
| | I need help on my update statement, the condition is , i have to update the status . the table name is leave_request , it contain leave_req_id, date_applied,emp_id,leave_type_id,leave_period_id,leave_status and the default for leave_status is 'Pending' the problem is, choose approve, and on the database should change the leave_status into 'Approve' … Databases mysql |
 | how to assign roles to users in Database ? mean i have admin, applicant ? so how could i differentiate bw them ? HELP !!! Databases |
 | Hi everyone, Trying to do a subquery to select the minimum price from table1, table what holds 15 million rows. I think that my approach is not the most suitable way of doing this. I want to select after oen_norm because oen_norm may have 1-10 rows per entry, but I … |
| | Good day. I have this running query that I want to pivot the sum of CurrentBalance where in Monthdate =[2011-11-30],[2012-12-31]...etc. But everytime I try to put the Pivot, it cannot detect the CurrentBalance column alias. Here is my query so far. use MFR_Merchandise go declare @MonthColumns as nvarchar(max) declare @SQLtext … Databases mssql |
| | as the thread name $query2= "alter table employee_leave_quota auto_increment= LAST_INSERT_ID()"; That is my query to reset auto_increment in my table, but it show error.. anybody know how to do it? Databases mysql  |
| | hi, i write a code like this $user_id = $hd_cookie['user_id']; $user_password = $hd_cookie['auth']; $sql = "SELECT * FROM hd_users WHERE user_id='$user_id' AND user_password='$user_password'"; $r_user = mysql_query($sql); $num=mysql_num_rows($r_user); //line 24 it shows Warning Warning: Supplied argument is not a valid MySQL result resource in c:\apache\htdocs\helpdeskfinal\includes\auth.php on line 24 when i print … |
| | Here is the code I'm running into an error with: FROM IndexPID INNER JOIN Demographics ON IndexPID.NDoc_Number = Demographics.NDoc_Number, PatientSupply INNER JOIN Demographics ON PatientSupply.NDocNum = Demographics.NDoc_Number I also tried it this way: FROM IndexPID, PatientSupply INNER JOIN Demographics ON IndexPID.NDoc_Number = Demographics.NDoc_Number INNER JOIN Demographics ON PatientSupply.NDocNum = Demographics.NDoc_Number … Databases sql |
| | Hi, guys i m already done with DB part of my project !!! but confused here !!! (Check attached image) Admin will enter all relevant details in applicant-scrutiny table for each user ........but i want that value for each userid (foreign key) should be copied automatically !!! NOTE: USER table … Databases client-server sql |
| | Hello! I need to write a query that selects TableID (a previously concatenated string) and also selects a substring of TableID as another column. All data in TableID is in the format %System.Variable, %Class.User, etc. I need to select from the % to the '.' to return something like %System … Databases sql |
| | hello iam using oracle 10g express edition actually iam not able to connect to sql plus if i enter the commands it shows an error mesaage as "not connected".so i tried another way of opening by connecting in oracle 10g go to database home page and entered my password and … Databases oracle |
| | Here is the code that can be copied into sql server to better assist with what I am trying to accomplish. Hope it makes sense and post back with any questions you may have: create table #temp(period int, location int, custnum varchar(10), driver varchar(25), dollar decimal(10,2)) insert into #temp values(201201,221,'ABC123','dwcustcomm',52.37) … |
| | Not sure the best way to ask this question, but here goes... I have a Database table that has a column called pos_id that is an auto increment field, and I have used it as a tracking device for the next position number in a company forced matrix system... Now … Databases mysql |
 | I just finished installing ODTwithODAC112012 (Oracle Developer tool for Visual Studio ODT) on my system . Now I am trying to deploy dbmsclr.plb as SYSDBA from SQLPLUS But I am getting the error SP2-024 nothing to change. Here is the command window:- C:\>sqlplus /nolog SQL*Plus: Release 11.2.0.1.0 Production on Tue … Databases oracle visual-studio |
| | hi, just want to maek sure some thing. so i have a table called user. in user table i want to add a field called date of birth. but i dont know which type to choice. it has int, varchar, date, datetime etc. but no date of birth. do i … Databases sql |
| | Hey Guys, I've got a question that's gotten me stumped. Granted, i've been away from MySQL and daniweb for well over 18months, i've picked up pretty much where i left off back then, and am just filling in the blanks as i go along. **My question is:** i have a … Databases mysql |
| | Hi, I am new to Oracle. I have installed Oracle 11g R2 standard edition (server software, 2GB download from Oracle). I found that the 'Environment Variable PATH' has not been set. Which of these directory should I use for the PATH value:- 1. Oracle base, 2. Software location or 3. … Databases oracle |
 | hi guys i got some problem with this code error said that exact fetch row return more than expected rows CREATE OR REPLACE PROCEDURE "MAINTAIN_REQUESTSTATUS1" (emplevel IN NUMBER,eid IN NUMBER,depid IN NUMBER,teamid IN NUMBER) is lastreq number; seq number; stat NUMBER; tok varchar2(60); appr number; CURSOR c1 IS select empid … Databases oracle |
| | Hi everyone, I was in a group meeting for a project and my group members were talking about minimizing the number of tables and having two big tables and one or two small tables connected to the main big ones. The question is : What is better to have less … Databases |
The End.