7,494 Archived Topics
Remove Filter  | |
| | i have two columnns start date : end date 01/01/2012:02/01/2012 02/01/2012:03/01/2012 03/01/2012:04/01/2012 how do i use the end date as my start date? the given data is only the end date. Databases |
| | Hey guys! I am building a data base in SQL server and am hoping to get some advice on frontends. The database is going to log and report on employee productivity. We would like to be able to use the frontend's forms to enter date time and project info in … Databases user-interface |
| | 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 am fairly newbish at handling databases but I've come to think that it's the most powerful tool for what I want to accomplish. I work as an English teacher and I am trying to create a database that will keep track of the students' language levels. Kind of like … Databases |
| | I want to delete a table after 15 days automatically from the date of its creation , please soem one help me to find out the solution , Some one suggest me to use trigger but i search a lot but unable to find out the solution . Databases 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  |
| | I am new to sql .please help me with this . the following sql statement works when i use like this Dim' CmdStr As String = "insert into table1(id,name,ref,amount) select id,name,ref,amount from table where name = A" I want to copy rows from one table into multiple tables Dim CmdStr … Databases |
 | i have a signup form on my website for user registeration ....... so i want to make it secure , by secure i mean , Password should be encrypted etc etc.....or any other precautions for security i already used hash functions of MS SQL on password field through queries but … Databases asp.net client-server mssql sql |
 | 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 … |
| | I got SQL Server Compact I got a database called Pages and a row called pName the row contains page names, but some are upper-case I now want to make all these lowercase. So there is a page like Downloads, I want to change it to downloads is this possible … Databases mssql |
| | 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 |
| | Hi! I referred to this forum thread when trying to build a MySQL search query for my site: http://www.daniweb.com/web-development/databases/mysql/threads/53025/mysql-select-rows-in-a-date-range But I just keep getting this syntax error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to … Databases mysql |
| | 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 every one, I have 3 table table temp: Name | Description A | Description A B | Description B C | Description C table temp1: Name | order A | 5 A | 4 B | 2 C | 3 table temp2: Name | Payment A | 3 B … |
| | I want to creat a blog for my site, which is hosted on windows server. Can we host a wordpress site or blog on windows. Databases client-server microsoft 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 … |
| | CREATE OR REPLACE PROCEDURE transfer( crdtacno IN NUMBER, dbtacno IN NUMBER, amount NUMBER, transno NUMBER ) IS BEGIN INSERT INTO transaction VALUES(transno,amount,SYSDATE); UPDATE account SET accbal=accbal+amount WHERE accno=crdtacno; INSERT INTO entrylist VALUES(transno,crdtacno,'CR'); UPDATE account SET accbal=accbal-amount WHERE accno=dbtacno; INSERT INTO entrylist VALUES(transno,dbtacno,'DB'); END; /  |
| | HI GUYS .. im trying to make foreign key relation between whishlist_tbl(foreign) table and account_tbl(primary key) table both are integer data container ## scenario ## i have user deatail table that is account_tbl and whish list table i.e wishlist_tbl i want that when user make a wish book then he … |
| | 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, I'm not new to SQL or PHP, or basic queries of SQL databases, but I'm creating a site that's going to be dependent on having a really accurate search feature. Basically, I'm just looking for some help on how I can get started, because there's a ton of information … |
| | Hello everyone, I have a table called job.In the table two particular columns are empid and managerid.When I am creating the table I must ensure that the managerid should be an existing empid.How do I write the create table statement for this.I am using oracle 10g. Thank you Databases oracle |
| | I keep getting this error message 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 's Hits and had 24,000 listener sessions; over 30 days. Get 5 commercials a day' at line 7 <!DOCTYPE … |
| | 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 all, I'm having a bizarre problem with the most basic of logins. I'm using a function to pass two parameters, just email and password but it just will not work and I can't understand why. I ran the query in the database and it returned a COUNT value of … |
| | 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 |
| | Hi, I'm just want to ask if it's possible if I want to update multiple record with same condition at the same time. For example, I have a table named *userTable*, it has two field, *year* and *status* fields. On year *field*, it has value of years and on *status* … |
| | Hi, I want to create a procedure to delete Production.Product table by ProductID in AdvetureWorks Database. How to do it? Because Table Product's too many relationship :( THANKS! Databases |
 | Hi all ,, i wanted to dispaly unicode values I saved in database. I use mysql database collation type is utf8 I save my native lanugage characters 'Sinhala' in the database. Although I can see them database when I print them in browser it prints ????????? characters. what's going on … Databases |
| | 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 |
| | Hi all, Help me please. i have two table: outbox and contact. condition outbox table befor query/ insert. CREATE TABLE outbox ( id int(11) NOT NULL, phone_number varchar(30) NOT NULL, message varchar(200) NOT NULL, PRIMARY KEY (id) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; Contact table: CREATE TABLE contact ( id int(11) NOT … Databases mysql |
| | 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 |
| | I am trying to display my vbulletin usergroup ids for each user who posts an ad in my photopost classifieds. in doing this I can execute my code based on that usergroup id. I have been working on this for 3 days now and I just can't get it to … |
| | i have a database ,i want to make it accessible to 3 type of users(admin,applicant,official) with different permissions .... how can i resolve,what i modifications it gonna need like to table , relations etc Databases mssql |
| | 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 I am trying to add a new feature to a website to find any results within a given readius. I found a script online that will calculate this for me but I am having trouble combining this with the current query. Can anyone see where I am going wrong? … Databases  |
 | 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 |
| | I'm trying to make multiplication in web shop that will show real price: **discount * tax * product price * 1 piece= real price** But I just don't know how to do it, I try 1 million things, spend about 48h just to make it, but, without success, no matter … |
| | I need to order these dates in descending order (last should be first) and in fact how they now appear. However they do not necessarily appear like those so I need a SQL Order By clause to order these descending: 2012-01-23 09:53:24.097105 2012-01-20 17:31:57.565458 2012-01-20 17:01:09.154587 2012-01-20 16:28:40.685735 2012-01-16 12:03:54.99954 … Databases sql  |
| | 0 down vote favorite I am trying to write a script that will return the latest values for a unique documentid-physician-patient triplet. I need the script to act similar to a group by statement, except group by only works with one column at a time. I need to date and … Databases sql |
| | Example data in column1 2|3|3|3GES|5|3 |3|334|3ere||343 I would like to split this by pipes so I can update the corresponding other blank 6 columns in each row. Example Col1 Col2 Col3 Col4 Col5 Col6 Col7 2|3|3|3GES|5|3 2 3 3 3GES 5 3 I hope this makes sense! Any help is … Databases mssql  |
| | 1 down vote favorite You can't vote for your own post. (click on this box to dismiss) I have a very big problem with my website. I have a form, more like a text box used in submitting comments, that not the problem. The problem is displaying the comments. I … Databases mysql |
| | trying to develop a system to assign grades to students. The system reads marks from my database, and assigns a grade after getting average of scores. Used case statements, keep throwing errors. So i tried if statements but its giving me issues. Someone know a better way to do it? … Databases mysql |
| | Hey there I have two separate queries and I am trying to figure out how to combine them into one. I've verified separately each one works. They are: SELECT FACULTY_t.LastName||', '||FACULTY_T.FirstName AS "Committee", STUDENT_T.LastName||', '||STUDENT_T.FirstName AS "Student" FROM STUDENT_T, FACULTY_T Where STUDENT_T.CommitteeID = FACULTY_T.FacultyID and select decode(COMMITTEE_MEMBER_T.FacultyID,COMMITTEE_MEMBER_T.ChairPerson,'Y') chair from COMMITTEE_MEMBER_T … Databases oracle |
| | hi to all, i want to create user on student table IN ORACLE.... CREATE USER john IDENTIFIED BY out_standing DEFAULT TABLESPACE users QUOTA UNLIMITED ON users DEFAULT TABLESPACE temp QUOTA UNLIMITED ON system; but, oracle shows following error like...."insufficient priviveleges on password... please give some suggestion for creating user in … Databases oracle |
The End.