Databases Forum

hello, I'm kinda newbie in databases. I have a table like that: DB is MSSQL 2003 Name is varchar Fruit is int (i used the name just to avoid mess with numbers) the number and the type of the fruit is fixed (in real case are 1,2,3 and 4) Qty …

I want to write a MySql procedure which returns a formatted XML file i.e. 'OUT BLOB'. Has anyone come across such a procedure or is it better to make a Java etc... code do the same?

Hi, I just started using phpMyAdmin. I need to create a table with all the dates of the year. The date will be the primary key and for each date there will be five time fields. Is there any way to do that with one SQL query? Thanks in advance.

I need to choose a value from a combo box and check if that exists in a table and if it does..i need to make a button glow green.. I am not sure how I have to check if the chosen value exists in that table.. can you please help …

I have a table with 3 columns as follows: lower upper id 12 20 100 100 150 200 I want to select range of numbers based on lower and upper column. For example I want to display numbers between 12 to 20 or from 100 to 150. How to do …

On of my database stooped working. [QUOTE] mysql> check table invoice; +-------------------------------+-------+----------+----------------------------------------------------------------------+ | Table | Op | Msg_type | Msg_text | +-------------------------------+-------+----------+----------------------------------------------------------------------+ | billing_db.invoice | check | Error | Incorrect information in file: './billing_db/invoice.frm' | | billing_db.invoice | check | error | Corrupt | +-------------------------------+-------+----------+----------------------------------------------------------------------+ 2 rows in set (0.00 …

Does anyone know how to change the look of the java files that are listed when you expand the java folder in the tree structure of the database? i have these numbers infront of the class file, but have no clue what they are, they are not there in toad(i …

i have just had to go into the backend of an old site to fix the mysql db as some had deleted the wrong db. i have got most of it working again now but did not know what this line of code is doing. [CODE]$sql = "SELECT id,thumb,image,designer,title,(total/freq) AS …

[code=php] <?php $result = mysql_query("INSERT INTO ".UPREFIX."items` VALUES ( '', '".$item_name."', '".$item_descr."', '".$item_action."', '".$item_rarity."', '".$item_value."', '".$item_folder."', '".$item_image."', '".$item_cat_id."', '".$item_visibility."')"); ?> [/code] I didn't know if this would be php or MySQL. I'm getting returned the following error: You have an error in your SQL syntax; check the manual that corresponds …

Hi, I have "Balance" table that is shown below. Table :Balance todaysDate/openBalance/closeBalance ------------ --------------- -------------- 2008-07-24 250000 100000 Above record will be inserted into next row as it is at 10:00pm. How do i do this? Thanks

have had to move some file across from one server to another and i am now getting access denied for user. it also says it could not connect to the server. i have changed the site path so it is now the address where the files have benn moved across …

I am trying to find a way to calculate a running total of a field in my database, and while I have found a lot of good solutions, such as [URL="http://www.daniweb.com/forums/thread127644.html"]http://www.daniweb.com/forums/thread127644.html[/URL], they all require that I have a column which is ordered in the way that I want it to …

I am stuck between deciding between MySql and Oracle, The reason being, I want to know how long it will take for MySql to reash the level of the current Oracle, if its gonna take more than a year....I guess Oracle is worth the money else not. Any views on …

I have a query. Say in a notepad( D:\SQL.txt) I have 100 commands written in it UPDATE sal SET sal= sal+3000 select * from .................. insert into table tab_name values(........) insert into table tab_name values(........) insert into table tab_name values(........) .........so on Is there any SQL query like that if …

Can anyone suggest a good website that can teach me Oracle? thanks in advance..

Hi... I have a sql 2005 database called KN_online.. I have a stored procedure called Account_Login [code] USE [KN_online] GO /****** Object: StoredProcedure [dbo].[ACCOUNT_LOGIN] Script Date: 07/16/2008 01:01:34 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO create PROCEDURE [dbo].[ACCOUNT_LOGIN] @AccountID varchar(21), @Password varchar(13), @nRet smallint OUTPUT AS DECLARE @Nation …

Hello, If I have a table like this where i have the year and the month, how can a get something like 2008 3 after a select? - I mean the maximum month for the maximum year? Thank you. [CODE] year month 2006 1 2007 1 2006 2 2007 2 …

Hi There Normally I'm not designing database but have the need to implement an internal questionaire system. I'm wondering if anyone has examples of desigining a database for exams/etc? What I'm finding difficult is the need for multiple types of questions: 1. Multiple choice, one correct answer 2. Multiple choice, …

Hi, I'm developing issues database. How to get the ageing or how long the issues has been outstanding. TQ

hello guys, i wanted to write a query, or a view to be exact to display data from two tables as follow: 1. schedule_table (scheduleID as pk) 2. remarks (remarkID as pk, scheduleID as fk) meaning a schedule can contain many many remarks and non at all. now the problem …

Hi, I have noticed that a lot of newbies using MySQL ODBC driver on their Windows often come across difficulties testing the connection despite that they have created the database on their servers. If you can put our members through in step wise fashions, please respond to this tread. It …

Hi, How can i pick next or prevoius day in mysql? Any function like curdate() ? Thanks

Hi, [inlinecode]Select closing From balance Where account_no = 12 Limit 1[/inlinecode] returns an error "You can't specify target table 'balance' for update in FROM clause" Where is mistake? Thanks [code] AFTER INSERT ON Close BEGIN Insert into balance (date, opening, account) Values (CURDATE(), (Select closing From balance Where account_no = …

Hey guys, can someone please tell me how I can connect to a remote Oracle DB using WAMP (Windows Apache MySQL PHP) installed locally on my machine?

Hi all! I have been working on a relational database and have been putting it together as an ER diagram which I have attached (it has no relationships at the moment). [ATTACH]6773[/ATTACH] Here are how the tables are related: [B]Each[/B] Diary (diaries) has [B]many[/B] Questions (questions) [B]Each[/B] Question (questions) has …

Hi, I have been trying to get MySQL to work on my apache server with PHP on it. My Apache version is 1.3.29 and my PHP version is 5.0.0RC2. I'm also running Windows XP Professional SP2 32 bit. I tried modifying the php.ini file to load the php_mysql.dll, but I …

what is a database driver (such as microsoft provider) and a database provider(such as jdbc driver , odbc driver , dbole driver) and what the importance of each of them?

hi all, I want to calculate days b/w two different month like as 7/15/2008 and 9/30/2008 this is silly question but i have problm to calculte ti .Its urgent in projec

there is another problem that i am facing..i got 2 comboboxes filled with values from MS Access and they have values like 1.00,2.00,2.98,3.00,3.25 and 8.00 I want to be able to choose 2 values i.e. one value from each combo box and when I hit click I should get queries …

Sorry, I posted this in the wrong area (I'm using MySQL) Hello all: I'm currently building a website for a radio station and I want to setup a programming lineup. The fields I'm using are: ID Title Dayofweek (Show Day) Timeslot (Show Time) AMPM (AM or PM) Description Name (Host …

I have written the following Stored Procedure in an attempt to update two tables in the same database reliably but unfortunately it is not too successful. I ocassionaly end up with only the BundlesIssued tables updated and nothing in TicketsIssued. Please make suggestions on how I could make this stored …

Hi, Code below is wrong but i can't find the mistake. [code] Set @RecAdj:=(SELECT SUM(Paid) AS Total FROM payment WHERE PayDate = CURDATE()); if ISNULL(@RecAdj) set @RecAdj:= 0; end if; [/code] Or is there any other way? Thanks

hi, i want to select from more than two table using a single mysql query.please tell me a example query/. thanks in advance

Hi, Why a database with two words separated by a space causes problem to a bcp command like below : EXEC xp_cmdshell 'bcp [History Data].dbo.InventoryValuation_FP102008" out D:\test.txt -q -T -c' Do you guys met with the same problem before? If yes, how to solve it. Many thanks.

Hello everybody, i'm a newbie to MSSQL - so excuse the newbie question. i am creating a page wich is hosted like any other page on a web server, i need to somehow connect to a MSSQL server , wich is located on a normal computer and connected to the …

My website host supports MySQL and has a simple MySQL “workshop” available in their “V-Deck” (user control panel) to make simple tables for things like subscriber email lists, etc.. [B]My question is, can I use MySQL on my HTML web site, to update item prices on multiple pages at once, …

I'm a recent college grad and I'm building a database for my family business, which is a writing instrument manufacturer. I learnt about the concepts of subtype and supertype, but my professor told us that he almost never use subtype and supertype, instead he would do something else just for …

range of datetime data type (show all records in between 2 dates. example: form 2008/10/01 to 2008./12/12). thanks

Hi all! Ive created this code to read in data from several tables but i have a problem with SUM. With this code im trying to add together all the null values that have the most recent date but all the SUM commandi have does is multiply the number by …

Hi Guys, I have a text file which looks like this 123456 Amanda Morris and I would like it to look like this "123456","Amanda","Morris" The file has about 2000 lines how would I go about inserting the quotes and the commas. I use textpad to open the textfile and I …

Hi, I have an average cost greater than price crystal report for 20 different stores. I want to create a master report that lists all of the results over the entire company. Hence, I want to use union all in a SQL command for this master crystal report. For example, …

So I got this code off the internet. The guy who made it said this, "I have done this in SQL Server.If u want to do in Acess Database just create a table name USERS then add two fields name user_name and user_pwd thats it." I tried that and it …

hi. I'm trying to delete a row by specifying the actual row number. When I call all columns from one table it does work but when I already multiselect them I get an error: [COLOR="red"][I]Msg 4405, Level 16, State 1, Line 1 View or function 'Records ORDERED BY rowID' is …

I want to select data from ranges like Column1 Column2 25000 10 50000 20 75000 30 I want records like upto 25000, I get 10 upto 50000, I get 20 upto or more than 75000, I get 30 Can anybody suggest me a simple query for that? Thanks in advance,

I've taken over a site and i see certain tables being updated without any code on the site doing the update. (It's logical updates so I know its by design and not a hacker) What I can't see in PHP admin and I also have MySql Query Browser is to …

Is there anyway to have (in one query) two separate queries? For example if query one fails then it will not affect the rest of it. Example code: Say that the lastLogin table does not exist: UPDATE userInfo SET lastLogin=3 WHERE id=5 UPDATE userInfo SET LastLogin=3 WHERE id=5 Is there …

Why is this script not working.. [CODE] USE [KN_online] GO SET ANSI_NULLS OFF GO SET QUOTED_IDENTIFIER ON GO CREATE PROCEDURE [dbo].[UPDATE_PREMIUM_SERVICE_USER_EXEC] AS DECLARE @d24 datetime SET @d24 = DateAdd(hh,-24, GETDATE()) UPDATE PREMIUM_SERVICE SET nDays = nDays - 1 where Date > @d24 [/CODE] This is suppose to take 1 day …

Hello all, This is my first post in a forum like this, I hope someone is able to help me! :) I found a post from about a year ago that explained how to use combo box parameters in a query, and I was wondering if there is a way …

I am trying to create website that has questions with drop down options. Do I need to know MySQL for that?

Is there a keyword in SQL that would allow you to select a value from a field in the previous row? I am looking for something that would give me the speed field value for the row before: [code]SELECT min(Parsed.Time), [Parsed.Number] FROM Parsed GROUP BY [Parsed.Rev Number] [/code]