7,494 Archived Topics
Remove Filter  | |
| | Hi guys, I need some help from you. I know it's lame to ask for help for college, but for oracle databases we have a professor that really doesn't know how to explain anything. We are learning it all theoretically and nothing practically and now he gave us a code … Databases oracle  |
| | Hi, Is there a way i can pass variable column names to a stored proc? Here's what i want to do: i have lots of tables and for each of those i want to select out a few columns. e.g from table titles i want to pick out title_name and … |
| | Does postgreSQL-IE perform indexing before searching for IMAGE data type? I am developing a CBIR system for social media. i have xml files of about 1 million flickr images. if i get to know of a DBMS supporting indexing on searches my work would become alot easier. kindly help me … Databases postgresql social-media |
| | i have a query is to lookup CREDIT_CARD table using CREDIT_CARD_ID and get the MIN_REPAY_AMT. if SUM(AMOUNT_DEPOSITED) < MIN_REPAY_AMT for that month Then populate 1000 else 0 i have attempted the query below kindly help me out and i am getting the following error. Error: [CODE]ERROR at line 2: ORA-00923: … |
| | Hi am really new with php mysql, i need help pls. I have created a email software in my server, there is a field for inserting email data info. Right now i am inserting these data one by one, but this is annoying and taking hard time. Pls help me … Databases data-structure mysql sql |
| | Hi everyone! i am developing an application using java and mysql as a database server. the problem is i want to change the default date format in mysql. i created a table like this; create table registration (registrationNo integer primary key, customerName varchar[50] not null, regDate DATE not null); so … Databases mysql  |
| | Hi everyone, First of all let me just tell you that I have never done database programming myself, and this is the first time I'm setting up a MySQL database via phpMyAdmin, so I could be missing something small but I'm sure someone will know the answer, anyways... I have … |
| | Hi, everyone... I have a question about sql .. Question: Customer | jan-april | may - august| september - december A |quantity | | B | | | C | | | How to use the SELECT command to retrieve data and the output is show like above. please give …  |
| | Hello, I need to connect to a DSN on a remote computer. I have found a lot of a lot of info on how to connect to a remote database from a local DSN, but nothing on connecting to a remote DSN. I am using asp.net, but help on solving … |
| | I am having a bit of difficulty in getting the right value. What I want to query is, the users who expire in 7 days, for example on 4th Oct 2011, the query should display the result of that particular day only. Right now I am querying as below: select … |
| | Hey, I new in MS SQL I got one question don,t know how to solve..? Display code, name, place , total contract quantity for top 10 buyers how to write in MS SQL/...? Databases mssql |
| | Hi, can anybody, please help me out. [CODE][B]select * from log where id <='%07%' [/B][/CODE] Am facing the syntax error, what is the actual query? my id look like this: 1.mtg10kl 2.mtg07kl 3.mtg06kl 4.mtg09kl I need the output this: 1.mtg07kl 2.mtg06kl please help me out .thanks in advance Databases mssql |
 | Does anyone have any experience using curl from MS Access. I would appreciate some pointers, Databases microsoft-access |
| | Hey all, I'm new-ish at MySQL and Navicat. I'm trying to import a file with about 1.16 million records and Navicat keeps "working" (I see the timer moving) but it actually stops processing records at 850,825 records. The log shows no errors whatsoever but I know there are many more … Databases mysql |
| | Can anyone help me with an Inventory System Design? Its got to track the location of items in the warehouse (and shop floor) for stocktake/empty peg etc... It has to handle refunds and sales. So far ive come up with: Product (ProductID, Name, ProductCategory,Description,Price,SupplierID) ProductCategory(ProductCategory) Location (LocationID, Description) ProductLocation (ProductID, … Databases |
| | I'm sorry if this should have been posted in the c# forums..... I have created a database for my website and am using MS SQL. This database will need to be accessed by users on the site itself, and from a .NET application. I am comfortable using MS SQL through … |
 | Hi, I installed MySQL from the MySQL site. The setup procedure required me to set an username and password, which I set as X and Y respectively (say). Then when I opened the mySQL command line client, it asked for password, and after providing Y, I was allowed in. Once … Databases mysql  |
| | how to call oracle report using form builder on which command button.If i press command button report should be run. Databases oracle |
 | Hi Guys, I have imported an excel document into MySQL to tidy up and make better use of the data but I am having problems running an update. All tables used as examples below; [U]Tables[/U] asset_register phone sim team The asset_register contains the following cols; [CODE] id INT, serialNo VARCHAR, … |
| | Hello guys! [CODE]"SELECT * FROM $tableName WHERE cata != 'abc' AND ORDER BY times desc LIMIT $start, $limit";[/CODE] Is there any reason as to why this block is not working? What is the rule for formating such queries? Thanks. Databases mysql  |
| | This is homework. Here is the problem: Produce a list of employee last name, first name and department name. Use appropriate, user friendly column aliases. This is from the tables [ICODE]DEMO.EMPLOYEE[/ICODE] and [ICODE]DEMO.DEPARTMENT[/ICODE]. The relevant column names are [ICODE]LAST_NAME, FIRST_NAME, DEPARTMENT_ID[/ICODE] (from [ICODE]DEMO.EMPLOYEE[/ICODE]) and [ICODE]DEPARTMENT_ID, NAME[/ICODE] from [ICODE]DEMO.DEPARTMENT[/ICODE]. As you … |
| | I am running a mysql query in mysql editor: select RegExCapture('sdfdj250043', '[a-zA-Z]{2}[0-9]{6}' ); Getting error: Function doesnot exist Trying to register the dll in mysql: CREATE FUNCTION RegExCapture1 RETURNS STRING SONAME 'RegExCapture.dll'; Getting error:SQL error(1126): Can't open shared library 'RegExCapture.dll'(errno:0) Can anybody help, where I am missing. Thanks in advance. Databases mysql |
| | I have a function C++ file, created in VS 2005. But I am not sure how to register that function in mysql, so that it get stored somewhere in mysql database and when the query runs, it should retrieve the func definition from the database itself.. Please guide me with … |
| | Hello, I know relational algebra uses sets which eliminates duplicates values but I'm not sure about one thing. Duplicate values are impossible to exist in a relation ever? For example I can never have a relation R(A,B) with values (1,2),(1,2) ? Or they get eliminated <b>after</b> a projection or selection, … Databases |
| | Hi, Am created a login and an user to access sql server instance and the database. [CODE]Creating Login: create login xxx with password='secret'; Creating User: use testdb; create user yyy for login loginname; [/CODE] And then i login with this login name(xxx) and also i can able to access the …  |
| | Hi I'm facing a problem. I want to join two table which are in the following format. Table 1 id - - name 1 - - xx 2 - - yy 3 - - zxz Table 2 id -- xx -- yy 1 -- 1 -- 1 2 -- 2 … Databases mysql |
| | Hi, I have a table QuestionAsked which contains a column DateofAsking. Now what i need is to extract each date value and check whether the difference between that day and the current day is 14 or not. If yes than i have to update a particular column in that table.I … Databases mssql |
| | Hi, I want to make a report of several fields - however, rather than showing each record for each field I just want to display totals. Given this I think it would read a lot better if I had the field headings in one column down the page, so it … Databases microsoft-access  |
| | I have two date field in a table. Start and End I need to run a query to find out which records in a period. For example, in database have two date fields (event_start and event_end) I want to find out all activities include in 13/8 to 15/9. Not use … Databases mysql |
 | Good Day All I have a File Format Defined like this [QUOTE]9.0 4 1 SQLCHAR 0 100 "," 0 ExtraField "" 2 SQLCHAR 0 100 "," 1 Descr SQL_Latin1_General_CP1_CI_AS 3 SQLCHAR 0 100 "," 2 ABREV SQL_Latin1_General_CP1_CI_AS [/QUOTE] and i use it like this [CODE]BULK INSERT dbo.TBL_CMPS FROM 'C:\\UNISA_IMPORT\\Final_Import\\Campuses.csv' WITH … Databases file-system mssql |
| | |
| | I have been trying to run a command from the SQL view I'm getting a syntax error [CODE] CREATE VIEW TopLevelCust AS SELECT Customer.CustomerNum, Customer.CustomerName, Customer.Street, Customer.Balance, Customer.CreditLimit FROM Customer WHERE (((Customer.[CreditLimit])>=10000)); [/CODE] Databases mysql |
| | I'm looking to be able to have users register on my site or the forums (or vice versa) and be able to login to either with the same details. Is this possible? I sure as damn hope it is!! Hellppp! Also, how do I have users register? myBB comes with … Databases mysql |
| | hi, how can i trigger an update query on a certain record if that record was not update within last say: 1 minute???/ can i doit without using any scripting? if can't then php. Databases mysql |
 | Good evening, So I am working on a php application powered with a mySQL. I feel I am an intermediate programmer in php and intermediate with dealing with mySQL. I have begun to research security as it is or should be in my opinion the core fundamental when building anything … Databases  |
| | Hi expert, When i try this script i got 2 esn number with different shipdate and supplierid. were us it should be the latest shipdate should be obtain. Any Idea guys. thanks. [CODE] TABLE1 ESN 123 TABLE2 ESN--SupplierID--Shipdate 123--40----------2011-04-27 123--14----------2011-07-02 Select vp.esn, us.supplierid, us.shipdate --(Select Max(shipdate) from TABLE2 where vp.esn … Databases mssql |
| | I'm a c++ server side developer, and someone has asked me to write a system for their small business, and I know nothing about the tools available. In fact, Im so out of date in this area, that my first thought was to use Ashton Tate dBase 4! anyone remember … Databases developer-tools gui ide user-interface |
| | [CODE]update companystatistic set ReferencePrice = (select ClosedPrice from companystatistic WHERE CompanyID= 310 and ResultedDate = CURDATE() - 1) where ResultedDate = CURDATE() and CompanyID= 310 [/CODE] I have a same code. But it's not work.. help me..! thanks all Databases mysql |
| | Hello all. I am in the process of piecing together a software project that I plan to use in the day-to-day operation of my service business. I'm sure this will be a simple question for someone here. I will be tracking employees, service tickets, clients, & client IT Assets. I … Databases sql web-design  |
| | Hi, I am building a database that will be populated with financial data. Taking into account what the data looks like, how the data will be organised, what I am trying to do with this data, my hardware, budget and competency, I am looking for the most efficient design for … Databases database-design open-source storage |
| | [img]http://i.imgur.com/ACkqA.png[/img] Create an E-R diagram for a medical clinic, using the following business rules. Use Crow's Foot notation: • A patient can make many appointments with one or more doctors in the clinic, and doctor can accept appointments with many patients. However, each appointment is made with only one doctor, … Databases |
| | I have a person table which specifies common attributes of sub tables teacher, student and staff. A person can be either teacher, student or both. I use the same primary key in sub tables which access the person table as foreign key (teacher_id, student_id is the same as of person_id). … Databases web-design |
| | VS 2005 I just started to realized the power of SSIS packages meaning I am very new. Anyways I built a package that pulls from one of my stored procs and creates a flat file out of it and then sends to an FTP folder Okay now the problem is … Databases mssql |
| | We use a single database in SQL Server 2005 and the size is around 190 GB. We plan to spilt the database in following methods; 1. single instance multiple database without synonyms 2. single instance multiple database with synonyms 3. multiple instance multiple database Need inputs on the below queries: … |
| | i have created a database on a temp site and i am making a form where uses can add or update information to the database that will then be displayed on a page in the site. Here is the code for the form: [CODE]<form action="leaderboard.php" mehtod="POST" /> <p>Points: <input type="text" … Databases mysql |
| | Hello all, I have a problem in building the query for search. I have a table which contains a column X stores numerous values in each respective cell of a row. For e.g. [CODE] rows Column X 1 120;132;143;154;165 2 122;134;543;566; [/CODE] What I want to do is to make … Databases mysql |
| | Hi to all, i need a help I have 2 tables namely subjects & marks. Subjects has 2 columns namely subject_id (PK), subject_name & class_id (FK). Marks has mark_id, student_id(FK), exam_id (FK), sub_1, sub_2, ... sub_n here sub_1, sub_2, ... sub_n are columns in 'Marks' table but actually they are … Databases mysql |
| | Hi there, Im working on a web database application and Im encountering problems to connect the database and the ASP.net page. The database is being detected but not the tables inside the database. Could anybody help me? Databases mssql |
| | Guys, I have 2 tables. My objective is to get the information from Table1 and place it to table2. the 2 tables have the same Itemnumber and DefectCode. How could make this in correct scripts cause when i make the script it triple the records. [CODE] TABLE1 ItemNumber---------Price---PO-------Code-Qty P300-1710-DROID-U--302.05--9100962--506--1 P300-1710-DROID-U--302.05--9100962--553--4 … Databases mssql |
| | My table has 4 types of "r1": 'Standard', 'HD', 'HD + DVR', 'None' There are 3 types of "status": 'NTC', 'Repair', 'In Progress' All I am trying to do is retrieve all of the rows where r1 = 'Standard' and matches all three of the "status": [code] SELECT * FROM … Databases mysql |
The End.