Databases Forum

I'm developing a very simple VB app in Visual Basic 2008, where i have a textbox being dynamically updated with a value every second, i need this value to be inserted into a mySQL DB, i have made the connection ok but not too sure how to structure the VB …

Hey there, I have a code to remove the duplicates in one of my table but I cant seem to be able to ORDER the way mysql select the values. Here is my initial table: [url]http://img196.imageshack.us/img196/2421/tablesw.jpg[/url] [CODE]mysql_query("CREATE TABLE new_table as SELECT * FROM test GROUP BY url") mysql_query("DROP TABLE test") …

I have installed oracle10g ExpEdition,it hasn't inbuilt table. I need oracle tables emp,dept,salgrade,mgr.If you have installed oracle9i , you can easily export the tables. I am describing the method. [ICODE]open command prompt type C:\>exp scott/tiger file="c:\emp.dmp" tables=(emp,dept,salgrade,mgr) [/ICODE] then go to c drive,You can see the exported emp.dmp file. Please …

I have a potential client that wants to reproduce certain features from a website. That feature is something that I may need to create from scratch or I maybe able to find some type of plug-in application. Some research has informed me that there maybe some type of database involved,and …

Hello: Soon I will need to have my foriegn keys working. I have tried to set them up with no luck. Could someone show me how to set the payee_uid below? I am using an Apache Derby Embbeded Db 10.5.3. Thanks [code] stu_uid VARCHAR(11) PRIMARY KEY, stu_password VARCHAR(11), stu_lname VARCHAR(20), …

Hello, I have a SQL Server DataBase and have about 10,00,000 entries to be inserted into the database before the database becomes operational. I am currently performing an insert query for each entry, as they have to be read from a file and decided into which table they should be …

Hello there, Im trying to write a query where if a query is run on a set of tables and the result of that query is null then i want it to run a different query based on different tables. i.e. [CODE]SELECT CASE WHEN (Resulting Value from this query is …

updating into two tables is possible?

Hi, need help with inputing images to mysql. I read lots of previous thread about it but couldn't find the proper answer. this is code for my basic form: [CODE]<form id="form1" name="form1" method="POST" action="<?php echo $editFormAction; ?>" enctype="multipart/form-data"> <table width="100%" border="1" cellspacing="1" cellpadding="1"> <tr> <td>tytul</td> <td><label> <input type="text" name="tytul" id="tytul" …

I have database for a project i'm working on. yesterday i restored it from an old backup and the schema changed back to a earlier state. but now all the sstored procedures , views etc are missing and the project system can't use it and work. so is there any …

I have 3 tables. Here is the relevant information needed for each. items ------ prod_id order_id item_qty orders -------- order_id order_date order_status acct_id accounts ------- acct_id is_wholesale items is linked to order by the order_id and orders is linked to accounts via acct_id I need to sum item_qty for all …

let output string will be, str="01/Mar/2010,02/Mar/2010,03/Mar/2010,04/Mar/2010,05/Mar/2010" Some manipulation, ******* Resultant string should be, "01/Mar/2010,02/Mar/2010<br/>03/Mar/2010,04/Mar/2010<br/>05/Mar/2010" Here I want to replace Comma (,) by <br/> Note: I want to replace even commas only. (before 03/mar/2010 & 05/Mar/2010..like)

Hi, what would you recommend as the best book for someone *new* to SQL and SQL Server (specifically 2005, Developer version)? Thanks!

Hi guys, I'm learning basic SQL. I have a query I can't solve. Need to create a query named Task1D to list the last name, first name, number of matches, total number of points, for players who have played more than 10 matches and scored more than 330. A portion …

Organizations make business deals with other organizations. When negotiating a specific deal, each organization is represented by one lawyer. The same organization can have deals with many other organizations and it might use different lawyers in each case. Each lawyer has a first and last name, address (Street, City, State, …

Greetings - I need your help. I have an SSIS package with a [icode]Data Flow Task[/icode] which has the following Data Flow tasks: [icode]Excel Source[/icode] -> [icode]Data Conversion[/icode] -> [icode]SQL Server Destination[/icode]. The data in my Excel worksheet contains strings as well as numbers. (Also has some blank cells.) I'm …

Hi there! I´m with some difficult to do this query. I have this: [CODE]SELECT IDReport AS [ID Report], IDHardware AS [ID Hardware], DataHoraReport AS [Último Report], Versao AS Versão, DataInstalacao AS Instalação, DataUltimaActualizacao AS [Última Actualização] FROM Report[/CODE] in which result this: [URL="http://img189.imageshack.us/img189/6872/26352213.png"]http://img189.imageshack.us/img189/6872/26352213.png[/URL] How can i query those results to …

G'day, I've got a small problem. As all who post here usually do. I've got my table [CODE]CREATE TABLE IF NOT EXISTS `attractions` ( `attID` int(11) NOT NULL AUTO_INCREMENT, `attName` varchar(255) NOT NULL, `adultPrice` double NOT NULL, `childPrice` double NOT NULL, `referenceID` int(11) NOT NULL, PRIMARY KEY (`attID`), UNIQUE KEY …

I want the list of columns whose datatype is "date" from mytable in oracle. how can i do this. which query is used t fetch such column names?

I am trying to create a set of league table in MySQL and PHP. I can get the tables to show the top and bottom 5 values but the problem is when I have less than ten records in the system. When this occurs the same people can appear in …

[COLOR="Red"]I can't login on the server giving error: 17892. I want to drop the trigger but , as soon as I tried to login, the trigger(Tr_ServerLogon) get executed and login failed.[/COLOR] [CODE] CREATE TRIGGER Tr_ServerLogon ON ALL SERVER FOR LOGON AS BEGIN INSERT INTO AuditDb.dbo.ServerLogonHistory SELECT SYSTEM_USER,USER,@@SPID,GETDATE() END GO /*Where …

Hello again I have 1 well working function and one working stored procedure which counts the quantity of rows in table. Now I've created special table which has only two rows 1. Id (int null)(!++) 2. Rows(int not null) In Rows I want to store the quantity of rows from …

Hi, I would like to get help in designing a table for representing a range in a column. Lets say we have a excel sheet of a matrix like below. GameName | agegroup 20-24 | agegroup 25-29 ------------------------------------------ Cricket | ------5--------|-----7------ Football | ------3--------|-----9------ Lets say the numbers represent the …

Hi, I was wondering if someone could help me, i have nearly complete my site and need some help creating the queries to produce my commission and pipeline. my table structure is: [CODE]CREATE TABLE `pipeline_commission` ( `ProductID` varchar(75) NOT NULL, `Pip_CommID` int(11) NOT NULL auto_increment, `PipComm_UserID` int(11) default NULL, `clients_ClientID` …

I have an mssql database that I need to migrate to mysql. For some reason though any queries to any columns of type datetime are returned in French in the following format: 7/avr/2004 14:00 This also includes all the text of an SQL dump which not surprisingly makes mysql unable …

Is there a way to get a distinct value from a table and echo it as a id for a div tag and still have the rest of the values echo too? Say I have a table with these values: category item With 3 categories each having 3 items I'd …

Hello All, I am new to SQL Server 2008.I was just wondering if there is any way to add a user as an admin in SQL Server 2008? Is it possible to do using SQL Server Management Studio? Thanks.

[CODE]#---------------------------- # Table structure for litorder #---------------------------- CREATE TABLE `litorder` ( `id` int(10) NOT NULL auto_increment, `name` varchar(50) NOT NULL default '', `address` varchar(50) NOT NULL default '', `xdate` date NOT NULL default '0000-00-00', `ref` varchar(20) NOT NULL default '', `code1` varchar(50) NOT NULL default '', `code2` varchar(50) NOT NULL …

Hi, can anyone tell me why the below PHP code keeps returning mysql_num_rows(): supplied argument is not a valid MySQL result resource ?? [code=php] $result = mysql_query("SELECT * FROM RewardGenUser WHERE UserID = 123"); $num = mysql_num_rows($result); [/code]

I have a table having shop details where shop opening and closing time are available. My need is to find shops that are open in a time range supplied. For Example: Shop1 opens at 9 pm and closes next day at 4 am. Shop2 opens at 1 pm and closes …

my leave table: Field | Type | Null | Key empID int(11) NO EMPDETID int(11) NO Leave_ID int(11) NO LEAVEDATE datetime NO FIRSTHALF tinyint(3) unsigned NO SECONDHALF tinyint(3) unsigned NO REQPENDING tinyint(4) YES APPROVED tinyint(4) YES REJECT tinyint(4) YES my lev_definition table: Field Type Null Key LEVID int(11) NO PRI …

Hi, I have a dropdown box extracted from MySQL database and I have two records for a product as it was produced in different years. i.e. model number 75 repeated, I am trying to extract only one of them in the dropdown box and have used select distinct but it …

Hi I have installed Microsoft SQL SERVER 2005. This consists of the Configuration tools(SQL server configuration manager,SQL Error and usage Reporting, Sql Sever Surface area configuration, Reporting Services configuration) and SQL Server Management Studio. However I dont find SQL Server Business Intelligence Development Studio. Can anybody tell me how to …

How to Rename stored procedures in PL/SQL Is there any query for that?

Hi I recently instaled oracle11g but when i am opening sql*plus it's asking for enter username I entered scott then it's asking for password when I am trying to type password it does not type any thing and finaly it gives ora-25000

Dear Friends I have created the attached database for hotel reservation system and I don’t know if it is correct or there is something wrong with it. I would be very grateful if someone could have a look at it and give me some feedback on it. If there is …

im making a ASP.NET web application using a serverside database. Hi :), im making a ASP.net web application with a sqlserver backend database. i have been requested to provide both UML and ERD/Normalization i can do both of these techniques individually to a reasonable standard, however i am unsure about …

I'm designing a new database and I'm hoping for some advice or recommended reading...basically just where you think I should go from here. The database is for holding contact information. The contacts are of various sorts for our business: customers, friends, colleagues, contributors, etc. We want to use the database …

Hi everyone, I'm trying to write some PHP code to update a user's password. It is not updating and I can't spot what's wrong with my query (I have echo'ed it to the screen). [CODE]$sql="UPDATE $tbl_name set 'password'='$new_password' WHERE 'user'=$user;"; $result=mysql_query($sql);[/CODE] SQL statement [QUOTE]UPDATE user set 'password'='2' WHERE 'user'=test;[/QUOTE] What's …

hi experts SELECT porh.segment1, CASE WHEN popr.action_code = 'APPROVE' AND prall.full_name <> 'Sudheer T. Paraputhra' AND grdpr.short_name < 'PS-10' THEN prall.full_name END directman_pr,[QUOTE]to get the dept.head[/QUOTE] porh.description, porl.line_num, CASE WHEN popr.action_code = 'APPROVE' AND prall.full_name <> 'Sudheer T. Paraputhra' AND grdpr.short_name < 'PS-10' AND poph.action_code = 'SUBMIT' THEN TO_NUMBER ( …

Hi, i'm using .Net framework 1.0 & MS Access 2003 database. Using ODBC connection, I want to list all tables in ms access database in a listbox....Please help me.... very urgent...

Hello, I have a website (in development) with sql express 2005 db, and I want to upgrade to express R2 2008 version (mainly because of 10gb vs 4gb max db size), how do I do that?, I have win xp os do I need to upgrade to win7? Also I …

When I edit the information from a database table from my program I have made, I get this error: [COLOR="Red"]Cannot update identity column 'ID'.[/COLOR] How do I [COLOR="Red"]SET IDENTITY_INSERT[/COLOR] To ON?

G'day, Just a simple question. Does MySQL Support Inheritance? I understand that both Oracle and PostgreSQL support Inheritance, but haven't seen anything in MySQL regarding this. Regards, TC

I have created a database for a hotel booking & billing system, can't seem to stop from booking same room on sdame dates. Have indexed so that can't book in on the same day, but can still book the next day. Any clues?

I am using Eclipse and TomCat to a Oracle 10g database. Using SQL developer I can enter multi-language characters into the nvarchar2 columns. My application creates SQL update Strings that look like this: [code] update CLIENTINCUMBENT set UNITCODE = UNISTR('66'), EMPLOYEECODE = UNISTR('000607'), LASTNAME = 'Ыфтвууз', FIRSTNAME = UNISTR('Ощрфк'), JOBCODE …

Hi, I can't find the missing thing in this code. "05-MAY-08" is in the table but, [inlinecode]( CURSOR_TARIH%FOUND )[/inlinecode] never returns TRUE. When i do manuel query it is ok. Thanks [CODE] create or replace PROCEDURE A_SIPARIS_EKLE_SP IS CURSOR CURSOR_TARIH IS SELECT TARIH FROM A_ACCOUNT WHERE TARIH = to_date('05-MAY-08', 'DD-MM-YY'); …

Hi, Im working on a stored procedure to get monthly reports from a table. For that i need to develop a logic to perform the following function: suppose i give a start_date and end_date, i need to get the months split up between these dates. for eg) if I give …

I am having issues with the following script. I don't see anything wrong here. Very basic but it is giving me a headache. Any suggestions are welcome. I am running version 5.1.37 and the error is: Error Code : 1064 You have an error in your SQL syntax; check the …

Hi, I don't know if this is the right forum to post this, if not please move it or just delete it. I installed Phpauction via Fantastico after trying several purchased scripts that just wouldn't work. Everything is working fine except the "View Feedback" links which give the following error …