7,494 Archived Topics
Remove Filter  | |
| | Hi everyone! I have a problem updating my table named 'friend'. This is where I save my friend requests and updates it when a user accepts the request. My problem is when I accept a request, only one query updates. Separately, they work. But when I try to use the … Databases mysql  |
| | The date stored in my db is in the following format: 2011-06-10 17:15:26.000 2011-06-10 17:15:27.000 2011-06-10 17:15:28.000 2011-06-10 17:15:29.000 However I intend to retrieve the date above using the format below: 2011-06-10 How is it done? Your help is kindly appreciated. Databases mssql |
| | 1. employees table- emp_id is the primary key 2. department table-dept_id is the primary key. 3. Create or replace View emp_dept AS select e.emp_id, e.last_name, d.dept_id From employees e, department d 4. update emp_dept set last_name = 'munir' where emp_id = 11 ORA-01779: cannot modify a column which maps to … Databases oracle |
| | hi , i ma using the reporting service in MS SQL express 2008. but in the company i don't have the admin previlages to upload and create reports to the server. if i was to ask from the administrator to grant me the previlages what previlages does he have to … |
| | I am taking a database course and we are required to create some SQL queries. So don't give me the answer if possible. Just let me know what is wrong with this code: [INDENT]SELECT p.pat_id, p.pat_first_name, p.pat_last_name, p.pat_dob, ph.phys_last_name, s.service_desc, v.visit_date FROM Visit as v LEFT OUTER JOIN Visit_Service as … |
| | I would like to auto-generate a column which has a mixture of both numbers and alphabets. Like AA01 or AC24. I want to start at AA00 until AA40. From here i will go to AB00 until AB40, and do likewise for other subsequent alphabets until the last one which will … Databases mssql |
| | Hi I m Having a Problem in retrieving records. I want to get nth maximum value in a column. I have tried it using top select top n ColumnName from tablename where(select top n-1 ColumnName from tablename order by columnName desc) But i m getting all the n records. Any … Databases mssql |
| | We have 4 tables with field types like NVARCHAR and SMALLINT and we have 4 tables in the same database with VARCHAR and SMALLINT. The all reside i the same MSSQL2008R2 database with a database collationtype LATIN_GENERAL_BIN. If we run a simple query on the VARCHAR tables it comes with … Databases mssql |
| | Can i insert data from mssqlserver to oracle using select statement |
| | Hi everyone, Thanks for viewing this post. I have a question about SQL. May i know how to remove rows that have NULL value in one of the colums. SELECT name, grade, age FROM education If let say grade 1 of the rows is NULL, how do i remove that … Databases mssql |
| | i want try to update the value of record from table1 where the value i need is from table2 like: table1 [CODE]Item_id | Quantity 0001 | 100 0002 | 200 0003 | 300[/CODE] [CODE]table2 Item_id | Quantity 0002 | 100 0003 | 50[/CODE] [CODE]when the query run.... i want the … |
| | In my application some stored procedures are not working properly in current database of SQL Server. I have taken backup of database 2 weeks ago and all stored procedures are working in backup database. I have checked the properties of current database and backup database both are same. After restoring … |
| | Can anybody plz help me.. i need to find all the users who are grater than 10 days old. table name users ,fild contain with registration dates.to store date i used DateTime.Today with C#.Can any body give me a sql query to slow this |
| | Here is the condition,i have a table with the records for every months per year. I would like to retrieve the records only for three months per year. Lets make this clear, the records would be around Jan~Mar or Apr~Jun or July~Sept or Oct~Dec. Current date is 1-May-2011, so the … Databases mssql |
| | Hey. i have a table that has the columns of A,B,C,D and another table that one of the coulmns the VALUES of A,B,C,D i am trying to subquery the 2nd table at the coulmn that stores the abcd. and the result act as a column name for the 1st table. … Databases mssql |
| | hi, i have in a table"visitdate1, visitdate2, visitdate3 and visitdate4" i also have in this table address fields of "housenumber, street, city, zip" i want to run a query which shows me the amount of visits to a house. should these be stored in different tables? thanks Databases mysql |
| | Hey guys.. could someone please help me with.. What wrong with this: [CODE] echo "<td width='25%'><img src='images/Lock.png' title='" . $row['username'] . "' - '" . $row['password'] . "'></td>";[/CODE] i Get only the username.. Cheers, Sagive |
| | Hi everyone! So I'm finishing a shopping cart, and there is just one thing that annoys me - the currency is on the left side. Its like this: $10, but I want it to be like this: 10$. Is there any way that I can do this? Thanks! Databases mysql |
| | Dear All, I have a big table of poi's based on latitude and longitude. So then based on a given latitude and longitude I would like to find the nearest point in my poi table. Can I use some mysql functionality to do to be best optimize way. The problem … Databases mysql |
| | Hey i m having this trouble and would like some help.....Can u seggest any things what i could do? the diagram i have is below the question. What other tables, attributes and relationships would be useful to create a more complete design? (You could do some research) Describe and draw … Databases |
| | I design an academic information registration system. I have 3 types of users namely teachers, students and operators. As all these have some properties in common I thought of designing it in the following manner. teacher([U]id[/U], profile_id) student([U]id[/U], profile_id) operator([U]id[/U], profile_id) profile([U]id[/U], first_name, last_name, tel) teacher_specific([U]teacher_id[/U], academic_qual) - teacher_specific has … Databases web-design |
| | Hi All! I have a zip code table that has the zip code, city, state and various other info in each row. The problem is that if I pull up all the cities in a zip code (say 33308) I get the same city spelled twice like this: [CODE]Fort Lauderdale … Databases mysql |
| | i have never worked with GIS data so i don't know much about it but currently i have just started my project and i am a bit confused while selecting the database for this purpose. i just want to know which database would be more fruitful while working in GIS … Databases |
 | Good morning everyone, I could be crazy but I am starting to work more on both my php skills and my mySQL skills, forgive me if I am asking the wrong question in the right forum or vice versa. [B]My objective[/B] I am building a script so when I log … Databases mysql |
| | Hi, I have to design an ERD based on these order and delivery note samples. Order sample -Order ID (random) -Customer's name -Customer's address -Date of order -table (list of item ordered) ID (ordered number, random) | Item's name | Description | Unit | Quantity Delivery note sample -Delivery note … Databases |
| | Hi guys. I am an IT student currently 3 days into my work placement which is the mandatory 3rd year of my degree course. I am working for a charity in England and my first task is to transfer data from excel sheets to a microsoft sql management studio database. …  |
 | I have made the mistake of adding a large amount of comma separated data to a specific field in a certain table without adding spaces between each! (Stupidly didn’t realise the associated application requires spaces!) Now I am trying to create a query that can add these spaces in automatically … Databases microsoft-access sql  |
| | I have two tables, Episodes and Seizures, with their respective Forms. On Episodes, I have a button the user clicks to open the seizure Form and its internal working is below. The problem is when the form is opened and filtered by parent form, the seizure form instead of filtering … Databases microsoft-access |
 | This question seems to always have 2 sides to it. If I make a [COLOR="Red"]register.php[/COLOR] with the registration form, should I have it submit to [COLOR="green"]processreg.php[/COLOR] or should it just process all on the same page? Same thing for login. I have read that it may e more secure to … Databases mysql |
| | I'm having problems with my query below. Basically I need to calculate the feet between two gps coordinates. Basically once I can get this formula completed instead of manually entering the data I'll use a temp table and then select the top 2 rows and then delete these and keep … Databases mssql |
| | I am creating a database in MS Access 2010, I have 6 tables. My question do all 6 tables need to have either a direct relationship (primary key to primary key) or Primary Key to Foreign Key with each other? Databases microsoft-access |
| | i don't know if it possible or not if i want to like this : Actually, i have one form "Product" In Form, i have two comboboxs , first name cboProduct that have Row Source "CPU;RAM" and second name cboSeries. what i want to do is when i choose a … Databases microsoft-access |
| | I'm looking to select almost duplicate rows in a table. I initially just sorted all the rows by name and picked out the duplicates manually (took a while), but I'm wondering if there's a "real" way to go about doing this. Problem is that the duplicate names can slightly differ. … Databases mysql |
| | how to find the last dml action held on which row in a table using mysql plz do me a favour , tanks in advance.. Databases mysql |
| | Alright, so I am embarking on a fairly large project that is complete with user profiles. My question is, what's the fastest, most efficient way to store user meta like books, movies, etc. I was planning: metaid | userid | firstname | lastname | movies | books | biography | … |
| | I have varchar value 4890 And i am casting it to decimal and dividing by 100000 Its output is 0.0489000 But when i calculated the same on calculator it gives 0.04890 And i think it should be 0.04890 Please help me out Thanking in Advance Databases mssql |
| | So I have this table checkout([U]cardNumber[/U],[U]libraryID[/U], checkoutDate, checkinDate, dueDate) that holds the checkin and checkout information for books in a library database. The trouble is I only now realized that with this set up a cardholder can't checkout the same book at a later date. I've been wracking my brain … Databases |
| | This is just to get some thoughts and opinions on how to handle my database. Okay so say I have a table for scheduled wrestling events that looks like this: [B]id[/B] : (auto- increment, primary key) [B]event_name_id:[/B] (id of the event name from the event_names table) [B]event_label:[/B] (label of the … Databases |
| | I am developing a project which is going to use this database table, but I am not getting the complete normalized form of this table. I am not practically strong with normalization so every time I try to make it I end up in no where. The table is attached … Databases |
 | I am using oracle 9i database with VB.NET when i am trying to insert record in my PR_REC table it gives me error "ORA-01722 Invalid number" here is my insert statement and the structure of the table [CODE]com = New OleDbCommand("INSERT INTO PR_REC(pr_no,item1,price1,qty1,item2,price2,qty2,item3,price3,qty3,item4,price4,qty4,item5,price5,qty5,item6,price6,qty6,item7,price7,qty7,item8,price8,qty8,item9,price9,qty9,item10,price10,qty10,Pur_reason,pr_date,Status) VALUES ('" & Me.txtprno.Text.Trim & "','" & … Databases oracle |
| | I've been trying to solve SQL exercises from [url]http://www.sql-ex.ru/[/url] for some time. You can find database description below: Short database description "Computer firm": The database scheme consists of four tables: Product(maker, model, type) PC(code, model, speed, ram, hd, cd, price) Laptop(code, model, speed, ram, hd, screen, price) Printer(code, model, color, … |
| | Hi I want to figure out a way to update multiple rows that depend on a couple of variables. I don't really know the syntax in SQL, but I know what I would do in C, so maybe if you could translate this... [CODE] switch (x) case 0: switch(y) case … Databases microsoft-access  |
 | EDIT* Sorry I didn't mean to add that error message in the topic title. Hey guys, I'm new to PHP and MYSQL and I have been searching for hours for a way to copy the data from a row in one table (all columns) and insert it into another table … Databases mysql |
| | Hi folks, this is my first post in danniweb, please excuse me if I am in the wrong place or the thread title lacks self explanation. I am very disoriented in the field since im new in MS SQL. Before going into the problem, I'm going to give some context: … Databases database-design mssql |
| | Hello all In my table mytable I have Date column. how is the query to find the nearest date in mytable to current date ? thank you denny Databases mysql |
| | [code=text]mysql_query() [[url]http://www.mysql.com/doc]:[/url] 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 'into kiwanis_info ( 'identity', 'firstnam', 'lastnam', 'phonenum', 'emailaddr', ' at line 1[/code] Above is waht I get when inserting into a file from … |
| | Hi there. I'm having a problem getting values from a drop down to insert into a table. What I want to do is get the key for the value and then insert that. For example: I have a table called format which holds an auto incremented ID key and a … |
| | Hi All , I tried to update the field RANGE_ALLOC_BLOCK_SIZE in table GLOBAL_VARIABLES of information_schema database.But i face the error Access denied for the root user.Can anyone help me to update the field. Thanks, Arun T Databases mysql |
| | I am trying to sum data from a database using excel. The following gets me results for one criteria but I need help with this formula for multiple criteria. In other words "sum values where condition is both criteria 1 and 2 at the same time"...the formula is below. Start … Databases |
| | I'm having trouble getting my queries to insert properly. this is my table structure books(ISBN(pk), authorID(fk), formatID(fk), publisherID(fk), titleID(fk), yearPublished) the ISBN and year are past directly via a form but the foreign keys are all auto incremented in their own tables. I was trying this: [code] mysql_query("insert into authors(authorName, … Databases mysql |
The End.