2,403 Solved Topics
Remove Filter  | |
| | I have following tables table1 nr_key1 nr_dad1 table2 nr_key2 value (repeated ~n times with same nr_key2 and different value) in table2 nr_key1 = nr_key2 After I have iterated through nr_key1 I want to use recursion to select nr_key1 = nr_dad1 and iterate again table2 with the new nr_key1. This should … |
| | i have a project that implements the using of database. i chose to use php as the application interface and mysql as the database. at the end of this month, we should submit the softcopy. now, i'm confused with the files of my project. i'm using wamp server, and in … Databases file-system mysql php |
| | I have some tables that i have created in SQL Server and i want to write a stored Procedure that will insert data on to one of my tables AND also be able to update say if i select record [CODE] CREATE PROCEDURE Sp_cust_SaveCustomer --ALTER PROCEDURE cust_SaveCustomer (@id int, @ … Databases mssql  |
| | |
| | or even make the searching faster when retreiving data. please kindly help me. thnx. |
 | I have a database that needs to hold names of people from all around the world. Some names have special characters in them such as é and ¢ Is there a character set I can use that will accept any character no matter what language it is (with the exception … Databases mysql |
| | I created some data files with 'outfile ' command. The files are created in the mysql folder.{I use WAMP} I want to create those files in another directory. How can I do that? Thankx in advance. Databases mysql |
| | Whenever I create a new database from a C# program and create tables for that database, the tables always show up under the creator's default database instead of being listed under the newly created database. This observation is from Microsoft SQL Server Management Studio Express. Is there some setting in … |
| | Hello i wish to retrieve rows from a table based on a particular column which contains null values in sql2000 server I try ed a lot but its not working please help me. Databases mssql |
| | One of the UPDATE queries I am trying to run is not quite working the way I want it to. I know this query is the culprit, but can't quite figure out how to fix it! Here's the story: ------------------------------------------------------- I have 3 tables: let's call them tblUsers, tblDueVisits and … Databases mssql |
| | Hello, I want to create database on SQL Server using Javascript and HTML. User will input following data. Server Name, Database name, File Sizes. When I will click "Submit" button database should be created on Selected server with entered name. I am using Client side HTML and Javascript. we need … Databases html-css java javascript mssql sql |
| | The reason is that : 1. I wish to run multiple databases on a single server. To do this securely each login must be granted db_owner on the database so we can use "deny view any database" to hide the other databases from view. (login can see all databases they … Databases mssql |
| | hi i have two tables, one is products, the other is for 'discounts' on those products... when adding a new 'discount' i want to avoid adding two discounts to a single product... so i was looking for some sort of Right Join which would exclude all products which have a … Databases mysql |
| | Hello all, i would like to know how it is possible to remove for example last 20 characters, or by specifing the string to remove. For example i have 2 rows (in reality there are more than 100, thats why im not working it out by hand) with the next … Databases mysql  |
| | I need some help I have managed to get this far (as below), from thatI can put a AAA_NUMBER and be able to get that record details and thats the 1st step that I wanted the 2nd step that I want is say if the DOCID is not available I … Databases mssql |
| | Hi, I've imported a Visual FoxPro database to MS SQL Server 2008 and had a couple of queries; The VFP tables used Numeric(5,0) for the Index fields, but I'm thinking of converting them to Integers in SQL Server. Is there any issues I should be aware of? A co-worker keeps … Databases mssql |
| | |
| | i am using SSRS 2005. In my dataset there are some blank rows and in SSRS is showing blank rows. Is there a way that i just show rows with data and ignore blank rows. i set the visibility property but it is showing blank line. dataset: a b c … |
| | Hello all, my first post. I have identical tables in my db. Is there a way to create a view with dynamic query to combine/union all the identical tables into one view? dbo.table.x-1 dbo.table.x-2 dbo.table.x-3 dbo.table.x-{n} Databases mssql |
| | Hi. I have a web application whereby I perform a search through 4 fields, namely:book serial no.,tel no.,gender and publishing date.In my jsp page variables picking the values respectively are:serial,tel,gender and datez.These are submitted to the java class.Currently, I perform my searches as follows(in java class): /***********************************************/ [code=Java]//......after connecting to … Databases java-jsp mysql publishing sql |
| | Hi, I hope someone can help me creating a sql for the purpose i have. I have a table named case_score_t with these columns: id, case_id, user_id, score, created_date I am interested in picking the rows with the greatest created_date, for a certain user_id. I now this SQL with give … |
| | I have around 2 million vouchers of some fixed denomination (say 10 and 20)[CODE]create table vouchers(pin varchar2(20) primary key ,amount number,status char(1),extra_value number); create index IDX_AMOUNT_STATUS on vouchers(amount,status);[/CODE]Typical values [CODE]amount,status ,count(status) 10 N 1000000 10 U 700000 20 N 300000 [/CODE]For each payment transaction,I fetch one voucher wrt.transaction amount and … Databases oracle |
| | I have be struggling to turn the below while loop into a foreach loop with no result, so I am asking for help here on how to do this. [code] $query = "Select * from TIME_TABLE Where Extract(month from DATE_FIELD ) = DATE_FORMAT(NOW(), '%c') and Extract(day from DATE_FIELD ) = … Databases mysql  |
| | could someone point out the error in the followin php/mysql code [code=php]$strSearchVal = $_GET['q']; //database connection.. //... $strSQL = "SELECT DISTINCT area FROM hospital where area like '%'+ $strSearchVal; "; $result = mysql_query($strSQL); while ($arrThisRow = mysql_fetch_array($result )) { echo '<li>' . $arrThisRow['area'] . '</li>';[/code]  |
| | Hi, I am doing a student progression system where the application is able to keep track of student marks. I have a problem currently and I've been spending nights on this. Let me briefly explain. Marks are calculated based on their hurdles. So for instance, H1 = xx%, H2 = … |
| | I am receiving MySQL error 1265 when I try to insert records into a table and after googling this error I am no closer to understanding the problem. Here is the error message that is returned: Warning Code : 1265 Data truncated for column 'DATE_FIELD' at row 1 Here is … Databases mysql |
| | how do i get started with MySQL and get the command prompt like MySQL monitor to write the command for creating a database in MySQL? Databases mysql |
| | Hello, Ihope to find some help in here, i have the following diagram [URL=http://img143.imageshack.us/i/13503390.jpg/][IMG]http://img143.imageshack.us/img143/6704/13503390.th.jpg[/IMG][/URL] and i want a query which return Emp_ID, Pro_ID note; i can get these values but by 2 queries as the following; [code=sql]select Pro_ID from Projects where Dep_ID in (select Dep_ID from Departments where name = … |
| | What is the best way to generate a set of dates based on today's date? Essentially, what I wanna do is: 1. Get Current Date 2. Populate a table with future dates 6 months apart and go up until I reach, let's say, 12/31/2020 I have looked at some of … Databases coldfusion mssql |
| | hi guys, I have 2 tables, one called neworders which stores the part_id and num or parts and a 2nd table called parts which has all the part details including cost. tables are as follows [code] neworder part_id(primary key) number_of_parts parts part_id(primary key) 7-8 more columns, eg size, desc, sup … Databases mssql |
 | Hello guys, how can to make correct query if in the typed values have a special chars (e.g. ' ") ? If the typed values have a one special char I know how to make the correct query, but if it have more then one special chars then I don't … Databases mysql |
| | Hello! I need some help please.. i searched a lot, and tried everything... can someone help me please.. here's the deal: i have this select: [CODE]SELECT * FROM localizacao, cliente, dispositivo WHERE disp_id = clien_disp_id AND disp_id = local_disp_id ORDER BY local_id desc[/CODE] it's output: [URL="http://i.imagehost.org/0746/tabela.jpg"]http://i.imagehost.org/0746/tabela.jpg[/URL] but what i really … Databases mysql |
| | As the title says, I'd like to select a certain number of rows from a table starting from a specified row. So for example, I have a table with 250 rows and the rows are numbered incrementally using a column called 'ref'. I now want to select rows 51-100. How … Databases mysql |
| | I am new at oracle and working on a small project. I am trying to find "[" in a field and produce from that point to the end of the field. My code is as follows: [code] declare startPos PLS_Integer; endPos PLS_Integer; begin set startPos := (Select top 1(instr(description, '[', …  |
| | I want to select from a table only when a field repeats more than once. For this I have: [CODE]Select title, Count(*) As Cnt From poss_titles where Cnt > 1 Group By Title Order By Cnt desc[/CODE] But it says invalid column name cnt. How should I refer to this … Databases mssql |
| | I'm developing a web page for a friend that allows participants of a sports event to "claim" a slot in a 24 hour tennis marathon. The marathon has room for 24 x 4 participants. My idea was to have a table with the columns "hour" [0-23], "time" and "name", and … Databases database-design web-design |
| | I'm using this piece of code to get the number of search results. However it says- Incorrect syntax near ')' (the very last ')' ) [CODE] SELECT COUNT(*) FROM (SELECT ID, ProductDescription FROM Products WHERE ProductDescription LIKE '%tech%') [/CODE] The inner select works fine and gives correct results, so I … |
| | hi, can any one tell me how to i use my sql sever's databse itno ms sql 2008 server. I tried to to do dat with the help of mysql backup file & execute it on ms sql server, but there are some syntax related problems. please help me. thanks … |
| | Hi, First of all, I'm no database expert. See me as managing a project where this problem occurs. We are building a system that will enable us to roll out Windows Patches automatically to all Windows systems we manage. We use WSUS on SQL Server 2005/SQL Express. The application will … |
| | I want to find the capacity of my data fields....how can i calculate capacity of varchar(10) or int(15)...???? (in kilobytes s or megabytes s) please help..t hankx in advance. Databases mysql |
| | Hi, I have 2 tables that I have made using sql create table which seem to work ok until I try to insert data into the 2nd table then it throws a: didn't add 1 record due to key violations. When I use the design wizard and do exactly the … Databases mssql |
 | Hi Everybody.. I installed wamp server and Mysql services doesn't start. I've found on Google Search. and nothing to solve my problem. Can anyone help me? Thanks.. Databases mysql |
| | hi to all, this might be very simple, but i don;t know how to get correct output, someone help me to complete it... [B]1st i need to get result from this query[/B] [CODE]$sql="SELECT * FROM $tbl1_name WHERE sex='$show_all'"; $result=mysql_query($sql); [/CODE] this'll result either all the boys or all the girls; … Databases mysql |
| | I need to query a database of application titles and count the instances of each title. I've already got a list<string> of distinct values from a previous query, and now I need to count how many times each value occurs. I'm not sure if the query is correct, or how … Databases mssql |
| | As the title suggests, I'm having trouble sorting the results of a union statement. I'm trying to sort the results by date descending and it's coming out ascending. [CODE=mysql] (SELECT a, b, c, d, e, f, date FROM table1 WHERE a=10 AND b=1) UNION (SELECT a, b, c, d, e, … Databases mysql |
| | Guys, I need your help as I really can't seem to start on this query.I seem to not be able to come up with any logic. I have to create a query for a table. I have two tables in my DB . First one is a book table which … Databases mssql |
| | hello, I'm trying to create a database in SQL Server management Studio for a project. I have created a tabel named Employee and I have 14 columns. I need to set the firts column (Emp_ID) as Primary Key (accomplished) and then generate a unique number for each Emp_ID that I … Databases mysql web-server |
| | Was just wondering if anyone here is an Access master have this code that I want too add a CHECK too but keeps on throwing a syntax error [code] CREATE TABLE Email ( userEmailAddress memo not null, timeDate datetime not null, contactEmailAddress memo not null, emailBoxType text(6) not null, readStatus … Databases mssql |
| | Hi! I am a student and I am working on database that concerns customer-order-product relationship. When designing it I encountered an issue that I do not really know how to solve it in the way it seems reasonable and obeys Normalization process. I would appreciate for any assistance. Description of … Databases database-design |
| | Okay idk if it's possible but I want one of my fields to have 000 as a default value and to maintain this value whenever called for. Like if I use PHP to run a query that asks for that field I want it to return "000". I'm doing this … Databases mysql |
The End.