2,403 Solved Topics
Remove Filter  | |
| | Good Morning... First let me start by thanking those of you that respond with great education information in here.. You have made my learning curve (time invested) much shorter than it would have been with just a reference manual. I know I still have a lot to learn, but this … |
 | ORA-01000: maximum open cursors exceeded tips I am getting following error. I made a combo box with select query behind it, i used itemlistener to fetch data. Today during testing i found that if user move too quickly in combo box so select query will be fired for each number … Databases oracle |
| | Hi, I recieve the following error message: "java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression'name '" when I run this statement: [CODE] sql = "INSERT INTO empDetail VALUES("; sql += txtName.getText()+ ", "; sql += "'" + txtAddress.getText()+ "', "; sql += "'" + txtSuburb.getText()+ "', … Databases microsoft-access mssql sql  |
 | hey there, I need an idea on how to store some information in a database. Let us assume that I want to build an application that allows a user to record what bars he visited each day. The number of bars is variable, and a user typically visits more than … Databases |
| | Hey guys! I have created an Access 2010 database. On one of the tables, there are fields [Start Time], [End Time] and [Total Time]. The user will input the start and end times but and the total time will be the difference between the two. I cannot figure out how … Databases microsoft-access |
 | I am developing a website that will host lots of user information. Things like avatar images, personal information, information about the users skills, etc. I will also be implementing a forum at some point. I am using a MySql db just to be clear. Ok now, I need some ideas … Databases database-design |
 | this is my query for displaying monthly business [CODE]select convert(varchar,dateadd(month,datediff(month,0,inv_date),0),101) as 'months with date format', sum(inv_amount) as 'business' from invoices inner join customers on customers.cust_id =invoices.cust_id where fname+' '+lname='lala fazlani' group by customers.cust_id,dateadd(month,datediff(month,0,inv_date),0) order by customers.cust_id,dateadd(month,datediff(month,0,inv_date),0) [/CODE] So when I execute this command, It gives me this result [url]http://img821.imageshack.us/img821/6492/sqle.jpg[/url] [url]http://img341.imageshack.us/img341/538/chartv.jpg[/url] … |
| | Hi, I'm wondering if anyone can help me develop the right sql query. I'm trying to select a "customerNumber" in table 1, but only if it doesn't exist in table2. I tried this [CODE]Select Table1.customerNumber From Table1, table2 Where table1.customerNumber NOT IN (select table2.customerNumber from table2) [/CODE] It isn't right … Databases mssql  |
 | Just doing some data base research just wondering Can the clustering of files occur after the files are populated with records? is this possible? Databases |
| | My final question. I have values which have been serialized into a table forum_polls as are in the following format as shown in the two examples below: [CODE]a:2:{i:0;a:2:{s:6:"answer";s:3:"Yes";s:5:"votes";s:1:"1";}i:1;a:2:{s:6:"answer";s:2:"NO";s:5:"votes";s:1:"2";}}[/CODE] [CODE]a:5:{i:0;a:2:{s:6:"answer";s:2:"CA";s:5:"votes";s:1:"1";}i:1;a:2:{s:6:"answer";s:4:"CIMA";s:5:"votes";s:1:"1";}i:2;a:2:{s:6:"answer";s:4:"ACCA";s:5:"votes";s:1:"0";}i:3;a:2:{s:6:"answer";s:5:"CIPFA";s:5:"votes";s:1:"1";}i:4;a:2:{s:6:"answer";s:24:"MBA(specify in comments)";s:5:"votes";s:1:"1";}}[/CODE] which unsererilized (I cheated and used an online unserializer) give: [CODE]array ( 0 => array ( 'answer' => 'Yes', … Databases mysql |
| | Hi all, I have a text file saved as utf8 without BOM. I loaded it into MysQL database. An iframe is loaded with this data from MySQL. I need the caret position in the iframe in order to perform operations in the database. Everytime there's a new line the positions … Databases mysql |
 | hi all, I need to join three tables my tables are ___________ markmaster ___________ stuid subid examcode mark ___________ _____________ subjectmaster _____________ subid subname subtype externalmark internalmark _____________ ___________ exammaster ___________ examcode examname duration description ____________ I need result like stuid,subname,subtype,examname,mark . Could any one guide to write query for … Databases mysql |
| | Hi- Probably pretty simple for experienced mysql-ers, but I'm at a loss... Say I have two tables: Movies & Reviews. Movies has a RecNum field, a Title field & other info Reviews has a MovieNum field (identifying which Movie RecNum it's for), a Rating field (1-5 if rated, 0 if … Databases mysql |
| | Hi All, I'm having difficulty in getting the data that I need from the DB.. and it is probably my lack of understanding in the query that I created... data looks like this in the table called RandPtrack rec_id type group_id open_date close_date orders shares order_date order_num 1 R 96 … Databases mysql |
| | Hey, I am trying to create this EVENT via phpmyadmin, but I get a syntax error which I cant see: This is the code for the event: [CODE] DELIMITER | CREATE EVENT delete_cart ON SCHEDULE EVERY 5 MINUTES DO BEGIN DECLARE cartID INTEGER; DECLARE cartProductID INTEGER; DECLARE cartAntal INTEGER; DECLARE … Databases mysql |
| | Dear All, I need your suggestion in developing a Database - I will use MYSQL as database. My database will have below specifications - - 1 table "Table-1" with 2 columns - DateTime and Integer Value - 1 table"Table-2" with 5 Columns - columns having process details (i am doing … Databases database-design |
| | This is how my license table look like.. i want to select only row that has atleast one "1". which means i don't want to select any row that has full of zeros.. Databases mysql  |
| | Hi all, Im running a update query like this to update multiple rows(about 1000). Example of query: [CODE]UPDATE DATA1 SET Column = CASE WHEN TIME = 0 THEN X WHEN TIME = 1 THEN y WHEN TIME = 2 THEN Z WHEN Time = 3 THEN Q END [/CODE] The … Databases mssql |
 | Alright, for some odd reason, the below syntax is incorrect. I have successfully connected to the database on previous lines, now i'm trying to create a table. The error I get is: [QUOTE]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version … Databases mysql |
| | Hi I am having a bad day! I am running an INSERT INTO and SELECT query which is working. One of the SELECT parts is: [CODE](SELECT title FROM exp_forum_topics WHERE topic_id = p.topic_id) AS post_subject,[/CODE] which brings back a title. What I want to do is prefix this title with … Databases mysql |
| | Hi I am having a problem with my syntax for the following code: What I am trying to do is: 1. Check if sticky = 'y' then give a value of 1 2. If not then check whether announcement is 'y' then give a value of 2 3. If not … Databases mysql |
 | |
| | Good Morning. Could someone tell me how you would go about doing a query to just get records that have an email account with(hotmail.com or msn.com or live.com) I'm sure I could do it by selecting the entire DB and sorting them in PHP based on exploding the email field, … |
| | [B] I will do an artifical intellegent project which is knowledge base system My question is Can I use [COLOR="Red"]ORACLE[/COLOR] database as knowledge base?[/B] Databases oracle |
| | I was browsing a MySql database using phpMyAdmin and I have probably inadverdently changed a setting. I have a field which contains quite large text entries. Before this problem arose the display showed just a few words of the text entry followed by a "...". Now the display shows the … |
| | I have 2 tables: 1. users - user_id(PK), firstname, middlename, lastname 2. user_shift_schedule - shift_code(PK), user_id(FK), effectivity_date I want to get all rows with the latest effectivity_date for each user_id. This is what I've got so far: [CODE]SELECT users.user_id ,users.firstname ,users.middlename ,users.lastname ,user_shift_schedule.shift_id ,MAX(user_shift_schedule.effectivity_date) FROM users JOIN user_shift_schedule ON users.user_id=user_shift_schedule.user_id … |
 | Good day, I want to delete a record from a single table but some of the filed on sigle record is related to other table on my database. how would i delete it.. i used this script delete from faculty deptid = (select deptCode from dept) all i want is … Databases mssql |
| | Dear All, I have a database with two columns, to keep several files of text with lots of text lines in each text: ----------------------- |---name -|- Text---| ----------------------- I want the column |-name-| to be a primary key, and to upload the text file I'm using the command: [CODE] LOAD … Databases mysql |
| | HI There This is the error I am receiving when trying to register on the site: Column count doesn't match value count at row 1 error: failed to execute query INSERT INTO users (uname,uteln,umail,ustre,usubu,ucity,uprov,ucode,uuser,upass,uc_dt) VALUES This is the regi.php coding. I cannot figure out the problem <?php if (isset($_POST['register'])) { … Databases mysql |
| | Hi everyone, I'm new to mySQL. I have a table like this one: [ICODE]+-------+-------+-------+ | date | plant | value | +-------+-------+-------+ | date1 | 1 | 10 | | date2 | 1 | 12 | | date3 | 1 | 15 | | date4 | 2 | 30 | … Databases mysql |
| | how can i select all records from a table where a future date column is less than 14 days away within a php table. somthing similar to? [CODE]SELECT DISTINCT FROM table WHERE 'Date_Column' <14 days [/CODE] Thanx In Advance KeeF |
| | *********************************************** select * from table_name where RIGHT_CODE IN (SELECT GROUP_CONCAT(''',`RIGHT_CODE',''')as right_code FROM table_name GROUP BY `GRP_CODE` , `ROOT_DESC` HAVING count( `RIGHT_CODE` ) >=2 **************************************************** Actually the above query returns empty result. But the query Inside IN cluase which returns ('1','28').. If i directly pass the value inside IN clause means … Databases mysql |
| | Hi, All i want to show is the 'fr_players' to have two categories of 'fr_nations' and 'fr_clubs' and fetch the names from the foreign id... Here what i have done so far but it doesnt shows any error or return any tables either: [CODE]SELECT a.id as club_id, a.fr_name as club_name, … Databases mysql |
 | I have a table in my database and i would like to bring up all the details where the datafield "votes" is the largest. i cannot get the fuctionality i desire. i would like a user to make a choice from the selection then have all the datafield where "votes" … |
| | Hi Guys. I'm having an error "Error No. 2003. Can't connect to MySQL server on 'localhost' (10061)". I am using windows XP in my laptop. Before, I have no problem in using MySQL. I also tried to connect using MySQL Administrator, but I got the same error. Sometimes I can … Databases mysql |
 | Hello everybody, My question is simple. I wish to develop a web site and I have been looking for web hosts and most offer MySql. At my job we use oracle, but after some searching I haven't found any great differences between them and any real reasons why I should … |
| | i want to find records between two dates IN ORCALE but the table field values is in "mm/dd/yy hh:mm::ss" and data type is varchar2 The query which i was trying was: [CODE] SELECT * FROM NEW_OUTPUT_UPLOAD_TSN WHERE OUTPUT_UPLOAD_DATE BETWEEN TO_DATE('01/13/2008 18:45:19','MM/DD/YYYY 24HH:MI:SS') AND TO_DATE('01/13/2008 18:45:19','MM/DD/YYYY 24HH:MI:SS') [/CODE] Databases oracle |
| | Hello Friends. Im having a problem in identifying the Provider for my MSSQL Server 2008. Can anyone address me the location of this information because I have to initialize it in my VB.et. As I understand for Ms Access it is something like [CODE]"Provider=Microsoft.Jet.OLEDB.4.0;Data Source="[/CODE] Can I know where to … Databases microsoft-access mssql  |
| | I am wondering if anyone wants to try and better this code sample. Here is the request: Given a range of dates (start, end) return all rows that cross that range where the rows contain a start and end date. This appears to work. I just wonder if anyone else … Databases mssql |
| | hi there i have problem with my MS SQL server some one execute unwanted update statement on huge table and make loss for my data i fix it by using available backup but, i need to know who,can i do it if there are some logs for sql statement please … |
| | I want to make option to approve users before they can login or to ban them, here is code [CODE]<HTML><HEAD><TITLE>Fakultet informacionih tehnologija</TITLE> </HEAD> <BODY TEXT="#ffffff" BACKGROUND="fakultet/Assets/bg.jpg" LINK="#FFFF00" VLINK="#CDCD00" BGCOLOR="#000000"> <CENTER><TABLE BORDER=0 CELLPADDING=0 CELLSPACING=0 WIDTH="700"> <CENTER> <FONT SIZE=+4 FACE="arial,helvetica"> Fakultet informacionih tehnologija <HR> </CENTER> <?php session_start(); // dBase file include "dbConfig.php"; … |
| | Hi I am using the fallowing code to give some information back to the user after running some queries. The information will be displayed in row only. [Code] $result1 = mysql_query("SELECT * FROM bookings WHERE bookingID='$last_insert_booking_id'"); echo "<table border='1'> <tr> <th>ID</th> <th>Firstname</th> <th>Lastname</th> <th>address1</th> <th>address2</th> <th>town</th> <th>postcode</th> <th>telephone</th> <th>email</th> <th>Arrival</th> … |
 | Hello Using MySQL, I have DB 1 with table T1 on Server 1 and DB 2 with table T1 on Server 2. Not on the same network and T1 contain the same columns with the same datatypes. I want to create a trigger on DB 1 so when there is … Databases client-server mysql |
| | Hey guys, I'm new to writing SQL and I need a bit of help. What I'm trying to achieve is getting my Java application to successfully send the high score of a specific user to a database. I'm not sure how I would write the SQL code so it will … Databases mysql |
| | Hi, I'm having a data base which looks like this patient(pk_id)--(fk_pat)appointment(fk_doc)--(pk_id)doctor(fk_spe)---(pk_id)specialty The goal is to select all the patients which had an appointment with a doctor with 'dentist' speciality. I made 2 requests, one is correct and the other is incorrect correct one: [CODE] select distinct patient.name from pataient, appointment, … |
| | Hi Guys, Can someone help me. I am using FCK Editor when I add a new news article to my website. When entering each new article, I have included an option where there is a drop-down list to select a particular news category. In the front-end of the website the … Databases mysql |
| | Hi a have 4 tables Table A ID | Data 1 --------------- 1 | A Table B ID | Data 2 ----------------- 1 | B 1 | C Table C ID | Data 3 ---------------- 1 | D 1 | E 1 | F Table D ID | Data 4 … Databases mssql |
| | Guys, Need your help. i need to obtain the nearest date from 3 tables. attached my scripst. th problem with this scripts it creates double entry in receipt date with the same transaction specially for this ESN "268435459407885398". [CODE] SELECT p.ESN, p.ReturnDate, s.Receiptdate, e.Shipdate FROM #Product p with (nolock) CROSS … Databases data-structure mssql |
| | I have two tables that I'm using in this query. We'll call the first one "userGroups" and the second "links". I've included their structure below. I have one system that is running an older version of MySQL, and I also have a system running a newer version. Older Version: 5.0.91-community-log … Databases data-structure mysql sql |
| | Hi, I am having trouble with retrieving records on my database. My layout was this.. [CODE]UsersList Username Firstname LastName Role Records TheUser ApprovedBy DateApproved [/CODE] The first text are the table names while the indented once are the field names. I have a table named Records. TheUser and ApprovedBy was … |
The End.