7,494 Archived Topics
Remove Filter  | |
 | 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 |
| | Hi All, I want to generate time table reports. A form includes labels to enter grade, class and stream. After selecting data user should click on "Generate" button and relevant time table details. The data is submitted for the following page and there was an empty set of data shown … Databases data-structure mysql |
| | Hi guys, i'm new here. First of all, i'm from Argentina... So maybe my english is a little crappy I'm developing a page with login. I uploaded it to a hosting with no poblem... But when i want to create a stored procedure an error appearse. I've searched on web … Databases mysql |
| | 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 |
| | Hi guys, I'm a student and need to practice Oracle SQL queries since we have Advance SQL in our syllabus. I have Intel-based MacBook Pro running Mac OS X Snow Leopard 10.6.8. I just downloaded the SQLDeveloper for Mac and unzipped it. The application executed and started well. But I'm …  |
 | 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 |
| | please if u can help me i have created a log in on dreamweaver and i had created one intranet in one company coz i have on study project to do i have created emploeys with their datas and created a log in form on dreamweaver but the problem is: … Databases |
| | 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 am tasked with designing a dating site in asp.net with VB using sql server 2005 as the database platform. I have not had a lot of advanced database design experience so I am hoping someone can help me out with this one.... For each user there is a profile … Databases asp.net database-design user-interface |
| | 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 … |
| | create table A ( id number(6) , Amount number(10) ); create table B ( id number(6) , Amount number(10) ); insert into A values (1, 50); insert into A values (2, 500); insert into A values (1, 600); insert into A values (2, 900); insert into A values (1, 600); … Databases oracle |
| | 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 … |
| | I have created two database tables, One which holds all of the users information, and another which holds the name of the videos they uploaded and who uploaded it. How do I get information from both tables? Databases mysql |
| | Hi, I have 2 tables tbl_class & tbl_Divisions. structure: tbl_class tbl_Divisions tbl_class_division ---------- ------------- ------------------- class_Id (pk) division_Id(pk) class_division_id(pk) class_name division_name class_Id(fk) division_Id(fk) In my application I want to select division_Id,division_name by passing more than one class_id. if I pass 3 class_Id's , I want to get only those divisions … Databases mssql  |
| | 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 |
 | I have no issues with the query in the below code. But the second code is throwing the error 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 '' at line 1 Working code … |
 | Hello hi. I am seeing flames with using FILESTREAM in SQL Server 2008! I have a table (Products), in which I wanna store a link to an image stored on disk, under the ProdPicture column. This is what the script looks like: CREATE TABLE PRODUCTS ( ProdID INT PRIMARY KEY, … Databases file-stream mssql perl sql |
 | 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 a table like this: tableA: id, a, b, c sample data: 1, x, y, sample1-get-by-y 2, x, y, sample2-get-by-y 3, x, '', sample1-get-by-x 4, x, '', sample2-get-by-x 5, '', '', saple1-general 6, '', '', saple2-general I want to get the data like this: if I have data where … Databases mysql |
| | Hi, I've two tables, one called users and one called playerweapons. In `users` it carries information and is defined by a Username field. In `playerweapons` it has the same define with using Username. I want it so when I update the Username field in `users` it will then update the … Databases mysql |
| | In sql server 2008, i have a store procedure which has insert statement , now i want to insert multiple records at a time into table via EXEC. MY Store Procedure: insert into tblUser(fullname, email, loginID, password, DOB, question, answers,doc,roleid) values (@fullname,@email,@loginID,HASHBYTES('sha512',@password),@dob,@question, @answers, GETDATE(),@roleid ) Now how to insert multiple … Databases client-server sql |
| | 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 |
| | Hi All, I have a samll problem related to a specific query. It creates following error. **Unknown column 'attendance_state.state' in 'field list'** $query="SELECT attendance_state.state,attendance_state.state_id from attendance_state inner join attendance on attendance_state.state_id=attendance.state_id where attendance.admission_no='".$admission_id[$i]."' and attendance.date='$date'"; $result=mysql_query($query) or die (mysql_error()); The table related to the query looks like this. "state_id" is … |
 | I am trying to do an INSERT statement. It is giving me an error #1064 - 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 'Telecaster’, 599.00)' at line 1 Here is the statement: … Databases mysql |
| | Hey Everyone, I am using the below query to try and group together values by the month of the date selected. the problem is that sometimes CTE2 will not have the same dates as CTE and those values end up omitted. Is there anyway I can just group these on … Databases asp.net client-server mssql 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  |
| | The procedure for Insert/update.I use datagridview get and display the data. I get the error message "Procedure or function Updatedata has too many arguments specified." // this is my Procedure ALTER PROCEDURE [dbo].[Updatedata] @item char(30), @uom int,@group int,@orqty int,@avgcons int,@reorder int AS BEGIN SET NOCOUNT ON; IF EXISTS( SELECT * … 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?> |
 | Are there any open source/free to use, commonly updated... either dumps or APIs that will let someone have zip codes and addresses validated? Think monster.com or careerbuilder.com's location search, or something similar. Thanks Ryan Databases mysql open-source |
| | Hi everyone, I had Oracle working perfectly fine and was able to connect to 127.0.0.1/apex . After a fresh re-install, I couldn't access the page. I can manage to log into oracle database by using SQL command line. I'm running Oracle 11g express edition. The message I get when I … Databases client-server oracle |
| | 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 the following codes.. echo "<form><center><input type=submit name=subs value='Submit'></center></form>"; $val=$_POST['resulta']; //this is from a textarea name='resulta' if (isset($_POST['subs'])) //from submit name='subs' { $aa=mysql_query("select max(reservno) as 'maxr' from reservation") or die(mysql_error()); //select maximum reservno $bb=mysql_fetch_array($aa); $cc=$bb['maxr']; $lines = explode("\n", $val); foreach ($lines as $line) { mysql_query("insert into location_list (reservno, location) … Databases mysql |
| | Hi, how many index i can create for one table in mysql. |
 | 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 |
| | I have a database created in mysql iwant to create a backup utility for backing up the data on a routine base 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 looked into Cast and Convert, but I cannot find a way to do this. I need to convert four digits into an hour format. For instance, 0800 would become 8:00 or 1530 would become 15:30. I cannot use functions, I'm using a special form of SQL. Any suggestions? … Databases sql |
| | 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 |
| | I want to make every single change on a local database to also be *immediately* done on the remote database. The remote database is always online but the local one is not. I was hoping of using RabbitMQ to queue the records so they could be sent immediately when the … |
The End.