2,403 Solved Topics
Remove Filter  | |
| | Not being a SQL programmer please forgive the following but I need to know. I have a MSSQL database with a table containing a row defined as Column Name Data Type Length Turnover decimal 5 also in Enterprise Manager I see Precision is set to 7 and Scale is set … Databases mssql |
 | |
| | Hi, [code] INSERT INTO table1 (supid, paid) VALUES ( (SELECT supid FROM def_1 WHERE id IN (SELECT id FROM def_2)), (SELECT paid FROM def_1 WHERE id IN (SELECT id FROM def_2)) [/code] This code returns more than 1 value, teherefore i can not execute it. Is there any other way … Databases mysql |
| | Hi, [code]select id, pay from def_1 where id = (select id from def_2) and pay = (select pay from def_2)[/code] This generates an error "Subquery returns more than 1 rows". Where is mistake? Thanks Databases mysql |
 | Hello everyone I am building on a little project in .net, but I have ran into some problems on database - level. I am creating a view with data from a couple of tables. It all revolves around my main table (let's call it 'main' for now). In 'Main' there … Databases mssql |
| | |
| | Hi friends, I think the MySql is not case sensitive for selecting values. for example I am having a table called dept, Id | Depart 1 | BTECH 11 | it 12 | ibt 2 | BE 21 | cse 22 | ece Now i want to select the capital … Databases mysql |
| | Hi, I am developing a hand held device. I am using .net compact frame work with WINCE support. Here i want to choose a open source database which supports WINCE. Can any one tell which open source database will support WINCE platform. Regards, Vijay Bhaskar Databases open-source |
| | I'm sorry but I'm totally new on Web Development, I'd like to make a registration form for everyone that downloads a file I have on a Website. The ideal thing would be to send a confirmation email where the link to file is attatched. So basically when a person wants … Databases mysql |
| | Hi All, When I run the query: [B]select (100/50)[/B] It give me "2"... good. But when I run the query: [B]select (50/100)[/B] I was expected it will give me 0.5... but it gives me 0 instead? Why? and How can I get the "0.5"? Databases mssql  |
| | I'm looking for some guidance on how to develop a msql query that loops through elemenets in a php array. The array is constructed from a multiple line list box. Databases mysql |
| | I am trying to create a sql statement like set @sql = 'select @stage1 = count(MY_ID) From VW_OPEN where ' + @filter and run it with exec (@sql) However this generates an error Must declare the variable '@stage1'. If I run statement select @stage1 = count(MY_ID) From VW_OPEN the var … |
| | Dear Friend I am trying to perform the flowing tasks using the following SQL statement in Microsoft Access but they don’t work. I wonder if someone could help and tell me what is wrong with my Statements. Whenever I run these statements it will not create the query. [B]Task 1: … Databases microsoft microsoft-access mssql sql |
| | Dear Friends I am relatively new to Microsoft Access and I have to create a report to perform below task, any suggestion, comment and advice will be really appreciated. Task 1: Prepare an order as a report (similar to the attached order form) to show an order for a customer … Databases microsoft-access |
| | I am new to FileMaker Pro 9 and have used MS Access a little. I am wondering if it is possible to transfer files from FileMaker Pro 9 (many files) to a web MS ACCESS database where another company where we send our data? Databases microsoft-access |
| | Hi, I am trying to install Oracle 9i but when it comes to Java Runtime Environment, it asks me path for it. I have JRE installed in my Computer. What else do i need to proceed this installation? Thanks |
| | is it possible to add a number to a number that is stored in mysql db without extracting the stored number first. i have a count and i am updating the count periodically but i would like to know if i can update the count while it is in side … Databases mysql  |
| | after i have run my query on a mysql db how can i set the result to equal a variable that i will use later on in the page. i have set the query up like this [CODE] <?php $rand = rand (0, 100); $query = "SELECT broad1 FROM images_broad"; … Databases mysql |
| | i have created a table to store the number of a count which i need for some subtraction at a later date. when i try to get the information out of the table instead of getting the number 5 i am getting resource id # 5. the table has been … Databases mysql |
| | Hi, I wan to know where the MySQL variables stored? when I execute the [CODE]show variables; show status; [/CODE] I see many more variables, so I want to know the place they are stored in? and the file name too? Databases mysql |
| | I use MS Sql Manager 2008. I need to extract some diagrams from my database. I tried to use reverse engineering in Visio but there is some problem with compatibility Visio drivers with my DB. Have any idea how to set up this and get the diagram(s)? Anyway I found … Databases database-design engineering |
 | hello, i'm fairly new to oracle, but i pretty much get it. anyway i've created a table using this code : [CODE]create table BanquetReservation( ResNo SMALLINT NOT NULL, Restriction varchar(30) not null, ResType varchar(10) not null, DateOfEvent Date not null, NoOfPeople SMALLINT NOT NULL, EndDate Date, StartDate Date, SSN CHAR(9) … Databases oracle |
| | Hi. I want to GRANT privileges on two tables, but I dont know why error, but on one table it is ok. what is wrong? [CODE]GRANT SELECT ON mysql.db, mysql.user TO 'user'@'localhost' IDENTIFIED BY 'password';[/CODE] I dont know why it is not working on two tables??? Databases mysql |
| | I'm getting this error message [B]An exception occured while executing a Transact-SQL statement or batch (Microsoft.SqlServer.Express.ConnectionInfo) CREATE DATABASE permission denied in database 'master'. (Microsoft SQL Server, Error:262)[/B] When I try to create a new database from the right click option on the master DB. I think this is a permission … Databases mssql sql windows-server windows-vista |
 | I currently have a database that is just one table with products and is using the myisam engine for the fulltext capabilities on two columns. The question I have is that this database has about 390,000 rows with a lot of duplicate entries namely manufacturer, price. I have been searching … Databases mysql |
| | Hi I created an DB, that export data to Excel and create a chart from this data, now I want to know, what can I do to filter data and set a criteria eg. A$2:D$46-range, Criteria =2. The filter is not working if I set that critria, for the data … Databases microsoft-access |
| | Hi Guys, I was just wondering if there's a way of restricting access to the contents of a database by creating a list of users and their corresponding password. So when ever someone tries to open the database a form pops up asking for their user name and password. Thank … Databases microsoft-access |
| | Hi everyone, Ima working on a business site similar to alibaba.com.In that we have a main categories named agriculture,chemicals ....so on. on clicking on agriculture we get one more subcategory containing different names line plant products,beans so on.. on clicking on beans we get the companies selling beans. similar to … Databases database-design mssql |
| | Hi All, SELECT * FROM Results WHERE ActualValue NOT BETWEEN Lowerimit AND UpperLimit In my query ActualValue is VARCHAR field. How can I get Results that are out of limit? Shrinivas Databases mssql |
 | Here is the code. For a short time, I will leave the test results up at [URL="http://superiorminitrucks.com/inventory"]superiorminitrucks.com/inventory[/URL] Clearly, I need to stop it from displaying the final entry twice.. Thanks in advance.. [CODE] <?php $db_connection = @mysql_connect("######", "#####", "####"); if (!$db_connection) exit(); mysql_select_db("tefflox", $db_connection); $result = mysql_query("SELECT * FROM trucks"); … 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 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 |
| | 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 … |
| | 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 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 |
| | 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 |
| | 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 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 |
| | 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 |
| | 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 |
The End.