7,494 Archived Topics
Remove Filter  | |
| | |
| | Hi Guys, I'm new here and have come across a perplexing problem. I have a user table [code=sql]CREATE TABLE Users ( UserID VARCHAR(64), UserName VARCHAR(50) ) INSERT INTO Users (UserName) VALUES ('Tom') INSERT INTO Users (UserName) VALUES ('Dick') INSERT INTO Users (UserName) VALUES ('Harry')[/code] Each user has roles and groups. … Databases mssql |
| | how can i understand nontrival can u explaing with example please? Databases |
| | I am joining two tables with INNER JOIN and I am getting duplicate entries. I used DISTINCT but its not working. Do we have some other keywords for the same? Thanks in advance, |
 | hi developers, i am developing a s/w that need a search. i current using "like" for search. for ex. [code] select * from Tabl1 where col1 like "% Software Developer %" And Col2 Like "% Software Developer %" [/code] But this is not right way. Am i right.? Please guide … Databases mssql |
| | Hi, I am making a database and currently trying to normalise it to bcnf, all my other tables i believe i have got correct and work in the best way. However i was wondering whether or not for my Employee table if using bcnf it is wise to try and … Databases |
| | I am designing a database for inventory management for a wholesale dealer. In my case, the firm will receive stock allocation but the actual physical stock will only be received later. So some times the actual physical stock received may be less than the allocation or vice versa. excess or … Databases database-design |
| | Hallo everybody, newly I installed OracleUnivEx 10g, and also I am able to connect to Oracle by its own Web-GUI, but the problem not recognising the MySQL commands like "create database "db_name"" and others like SELECT, INSERT, and ... any idea please? how to create database in Oracle and modefy … |
| | Hello Friends, I have three table and i want to select data from them Table 1 Roll No. --- Name---Age 1------------a--------12 2------------b--------13 Table 2 Roll No.---Name---Age 7------------d------12 8------------b------13 9------------c------12 Table 10 Roll No.---Name---Age 41---------d---------12 43---------b---------13 44---------c---------12 Table 3 Roll No.---Sex 1------------f 7------------f 41----------f i want to select date from Table … Databases mysql |
 | "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." Now this is a really stupid error. (yes that sums up the error S T U P I D) I am making an update to … Databases mysql |
| | Dear Friends I have finished the Data dictionary table for my assignment but I cannot figure out my (Composite and Foreign) Keys. I am attaching my physical data dictionary table with this massage. I would be very grateful if someone could identify them for me and update the table for … Databases |
 | I am helping a website owner to transfer a site to new servers. All site files have been uploaded onto the new server, only thing left is the database. In phpmyadmin, when I try to export the DATABASE to my local PC, using zip or gzip to compress, as this … Databases mysql |
| | We have given a project at school, we have to submit ERD next week... the project is as followes..... Software Experts(SE) is a consulting firm that specialises in creating custom software application for clients. When a client approaches SE with a project, the management at SE determine the staffing needs … Databases oracle |
| | I am reading records from a linked server table, and trying to use the output in the next update statement, not on the linked server. I am assigning it to a declared variable. The file is being updated with NULL, instead of the correct check number. Any help??? Example code: … Databases mysql |
| | Hi. Can anyone tell me how to find and install IIS? I need it for developing my mobile application with SQL Server Mobile and create a database. Or if you have any suggestions... Do you know any other way on connecting from mobile applications to databases (other than MS SQL) … Databases mssql |
| | Hi. Can anyone give me an idea on how I can create a search box just like a search box in the contacts window in a Nokia phone? Databases mssql |
| | Is this an appropriate place to submit a question concerning netbeans and creating queries? Databases mysql  |
| | I have a table which have person's name as Prefix, firstname, lastname, address as three different columns. I want to get all records when fire a query like SELECT * from Persons where name= 'abcd' I want such query which can search in all three columns, it means abcd can … |
 | Please tell me what I'm doing wrong. The sql query is in bold. [CODE]<?php //////////////////////////////////////////////////////////////////////////////// // // SECRET PAGE // // Invokes require_authentication() to ensure that the user is authenticated // //////////////////////////////////////////////////////////////////////////////// require("common.php"); require_authentication(); session_start(); ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd"> <html xmlns='http://www.w3.org/1999/xhtml' xmlns:b='http://www.google.com/2005/gml/b' xmlns:data='http://www.google.com/2005/gml/data' xmlns:expr='http://www.google.com/2005/gml/expr' xml:lang="en"> <head> … Databases html-css javascript mysql xml  |
| | I am able to connect to the database and located the table. I am unable to populate the db. Attached is a in image of the phpmyadmin trucks table structure. Please help. I am excited to be so close to getting it right. [CODE] echo '<blockquote><blockquote><blockquote>'; echo '<form method="post" action="/inventory/">'; … Databases data-structure mysql xml |
| | Hi all, I m converting stored proc from sql server to oracle. first have a look sql stored proc. create procedure xyz.. as begin -- i have created one temp table -- then inserted some data into it by select query over some db table. -- then i have another … |
| | helo there, i need some help on database design for the email/messaging system. tis is one of the module. but i duno how to design the table structure and flow which involved : sender, receiver etc. user A send msg/email to user B & user C, then the User B … Databases database-design email |
| | Hi, I'm designing a database for an E-commerce web project. It is a tennis equipment shop contains products such as Racquets, Balls, Apparels and other sports accessories. Each product have different sets of option (E.g Racquets have strings, tension, size and Apparels have color, size). First I was planning to … Databases |
| | Hi, I'm in the stages of building a beauty site that will include about 3,500 listings of salons & their services in my metro area. Since contact & service information changes consistently, I've considered a database driven website. In addition, I would like the search to pull results based upon … Databases database-design |
| | Hi all experts, Currently i have a problem coding in sql query and hope someone expert can answer me. I have a table with the following values (simplified) Name in_date out_date able 12/03/2008 14/03/2008 bravo 10/02/2008 17/03/2008 able 18/03/2008 null Ok so my result if i want to obtain results … Databases mssql |
| | Hello all, I'm having some problems with joins in SQL. I hope someone here can help me out a little bit. I'm using MS SQL 2000 Server. I have the following tables & data: [CODE] [B]Table: tUsers[/B] id location contact_id ----------------------------------------- 1 1 2 2 2 4 3 1 5 … Databases mssql |
| | I want to make a procedure that runs at every day at certain time. I read that I have to do Scheduling, but to do it I should have sql server agent. I am using sql server express edition with sql management studio express endition. But there is no sql … |
| | Well, i am facing this problem when i try to configure my ODBC 3.51 Driver. I had successfully installed MySQL. Then i try to install and configure my ODBC 3.51 driver. I add a new user DSN, filling with the correct username and password, with the data source name. However … Databases mysql |
| | I m retreiving some data by using cursor inside which i m calling one recursive user defind function to retrive all child data which is linked to parent. While executing i m getting error stating : [B]Maximum stored procedure, function, trigger, or view nesting level exceeded (limit 32)[/B] How can … Databases mssql |
| | Hi all... great forum! I'm basically on a crash self-learning course in Coldfusion and database-driven sites, so I'm pretty sure I'm missing some basic concept that would make this an easy query. If anyone could point me in the right direction I'd really appreciate it. This is for a site … Databases apple coldfusion microsoft-access sql  |
| | I'm a novice to Access and am learning using Access 2007. I've created my tables and established their relationships. I've created the forms using the wizard. I'm attempting to display summary data on a form but am not having any success. I have a SKU table and form. I have … Databases microsoft-access |
| | Hello all! I hope everyone is blessed and wonderful! I am in a quandry :?: , I have a form that I need certain people (3) to have full rights to edit/update/enter the data and then I have everyone else (approx 40) to be able to view only the information … Databases microsoft-access |
| | Ok, I have a e-commerce store that uses stored procedures to sort products. I have figured out how to sort my name and price but am having trouble sorting by rating bc the rating table doesnt have all the productids (only ones that have a rating) and also the rating … |
| | I am trying to insert tables into a database that I created at runtime, I am using MS SQL Server Express, and I have tested this query and it works, in the sense that a table is created. However the small text field (stringText [char]) only has a length of … |
| | Hi guys, Both cursor works if i don't use them in one Stored procedure. Both cursors return TRUE for(cursor_x%found). But, insert into process doen't work in cursor_1. Is there any structure problem? Thanks [code] CREATE OR REPLACE PROCEDURE ADD_RENTAL_SP IS -- cursor1 CURSOR cursor_1 IS SELECT ...... rec1 VARCHAR(15); -- … Databases oracle |
| | Hi, Where is the mistake? It doesn't work. thanks [CODE] CREATE OR REPLACE TRIGGER A_ACCOUNT_EKLEME BEFORE INSERT ON A_SIPARIS CURSOR CURSOR_TARIH IS SELECT TARIH FROM A_ACCOUNT where TARIH = SYSDATE; FOR EACH ROW BEGIN IF CURSOR_TARIH%NOTFOUND THEN INSERT INTO A_ACCOUNT (TARIH, PRICE) VALUES (SYSDATE, '1'); END IF; END; [/CODE] Databases oracle |
| | Hi, I'm creating a web database as a bit of learning project. In short it's going to a on-line menu viewer, where people can upload (type in) their food/takeaway food menus. The problem I'm having is with the design and as each outlet can have a differing number of starters/mains/deserts … Databases database-design web-design |
| | When I'm attempting to tnsping my database from the server it is stored on, I keep getting error code 3509, however I can ping my database from clients. I've checked naming in tnsnames.ora and all is as it should be. Any ideas??? Databases oracle |
| | I'm trying to carry out the following delete statements [CODE]DELETE FROM images AS i WHERE i.image_id = 803 AND i.plant_num = 2277 LIMIT 1 DELETE FROM images AS i WHERE i.image_id = 804 AND i.plant_num = 2277 LIMIT 1 DELETE FROM images AS i WHERE i.image_id = 805 AND i.plant_num … Databases mysql |
 | Hi Guys... i'm not so good at oracle, sql and related stuff.. but i do need to write some simple query's from time to time and i do need to understand that which all tables get updated by a particular transaction. I can do that by going through the code, … Databases oracle |
| | Hi, I need to send a SMS message or/and Email in my database project. Which one is better option for me; Shall i create database with Oracle or MySQL? Thanks  |
| | Hi friends, i got this err while executing this procedure. err is like this:- ----------------------------------------------------------------------------- 9/3 PL/SQL: Statement ignored 9/13 PLS-00201: identifier 'DATEADD' must be declared 11/3 PL/SQL: Statement ignored 11/13 PLS-00201: identifier 'DATEADD' must be declared ------------------------------------------------------------------------------ Please have look my stored procedure CREATE OR REPLACE PROCEDURE GReptExprtCompliTestRelt(EntityFolderCode number, … Databases oracle |
| | Hello :) , How can i filter something then turn it to filter again and one more time , like : SELECT * FROM Tbl1 WHERE BLABLA1 From those results WHERE BLABLA 2 And Finally , from all back results WHERE BLABLA 3. Real Example: Select all where : the … Databases mssql |
| | Hi, I can not use below code in stored proc in oracle; [code] IF (SYSDATE = '04-MAY-08') THEN ... END IF; [/code] This doesn't work either way (true or false). Is there any other way to check it? thanks Databases oracle |
| | Hello everybody!!!! I am just curious if I can make a database where all the data are images like bitmap, jpeg and other pictures format... If yes, can you pls show me some code or sites to where I can learn a lot about this.. YOUR HELP IS HIGHLY APPRECIATED.... … |
| | I'm brand new to SQL queries, hoping someone can help me set up this query. I'm using [URL="http://www.phplist.com"]phpList [/URL]to manage my mailing list. All user defined attributes appear to be stored in a table called phplist_user_user_attribute. The structure of this table is:[INDENT][U]Field[/U], [U]Type[/U] attributeid, int(11) userid, int(11) value, varchar(255) [/INDENT]attributeid … Databases mysql |
| | Hi, I need a trigger; - to find number 1 from "ID" column and - update "AVAILABILITY" column from Yes to No in "PRODUCT" table. Thanks Databases oracle |
| | Hi, 1- When i insert more than 30 datas (at once) into a table, does sequence cache size(20) effect anything because, i use sequence for auto increment in the table. 2-What happens if i increase the cache size from 20 to 50? thanks Databases oracle |
| | Hi, I put websites together using Xoops and OsCommerce. I need to know how to edit mysql databases using Cpanel. Please could you point me in the direction of some tutorials? There are some which show how to se up a database but not how to edit one. For example, … |
| | Hi Experts! I am professionally working in Oracle Developer 6i and database oracle 10g. but now i want to learn JDeveloper. I have no tutor available in my area. will you give me some tutorials or URL of tutorials... regards Khalid Mehmood Databases oracle |
The End.