Databases Forum

Hello, I am trying to make this code to combine the varchar string using fetch technique. The purpose for the code below is to combine all of the results and display back as 1 record instead of multiple records. We have SQL 2000 server. Thanks guys [code=sql]CREATE PROCEDURE get_all_clumns_name ( …

Dear everybody I have a question! I have a database with a invoice table for storing invoice data. In this table i use the InvoiceID as my invoice number. My problem is that if a user makes a mistake and the invoice is deleted in order to create a new …

Im having trouble with a running sum for my VAT analysis section of a report. Whats happening is the vat is calculated and rounded appropriately. But the running sum seems to be calculated on the pre rounded figure, is there anyway to rectify this. So i have following figures [I]245.70 …

New to Oracle. Using Crytsal 10. Unable to create views or Stored Proc on database. Having to just use SQL code in Crystal. Need to know how to pass variables from Crystal to the SQL code that will run on Oracle DB. Also can I create a temp table and …

hi friends, how can i store video files in the server or database like mysql, if u r having any related docs or code. please send it to my mail-id. otherewise tell me the way how can i store. i am waiting for ur replies... ok bye.. thanks in advance.

Hi folks, I have a mysql database and I have written some PHP to view records, add records, delete records and update records. The problem I have is updating checkbox fields of a record. Everyhting was working fine and updating correctly. Then I tried to automatically populate the form fields …

Hello everyone I am quite new here and have a very tricky issue that bothers since days. I posted the question on the PHP forum together with a sample of my embarrassing code. If this is wrong that I raise the issue here in MySQL forum, too, please forgive me, …

HI Folks, we have database servers of large application. we set initialization parameters log_archive_dest_1="/u02/fra" and log_archive_dest_2 ="/u04/data". But after some time being the parameter "log_archive_dest_2 " changed to "/u01/get" can u please tell me what are the operations on database can change this parameters values? As customer is naive he …

I'd like to ask a lil help from everyone. I have this problem. I have like items in column 1 & 2: COLUMN 1 COLUMN 2 0001 0043 0001 0056 0001 0078 0002 0043 I just need 1 row per distinct item in column 1 but I need the items …

In SQL 2005, if i update any value of a column in a table..... how can i get the column name(it should only return column names when any of its value is updated)

Hi. This is the first Topic I've posted at (the cool) daniweb site so go easy on me. I want to put the cities of England with all their districts in a database. I can think of the following two ways to do this: 1) [B]cities[/B] ([U]cityID[/U], cityName) [B]districts [/B]([U]districtID[/U], …

I'm trying to do a delete on two tables at once. sucessfully does it with update, [code] UPDATE table1 INNER JOIN table2 ON table2.table1_id = table1.ID SET table1.whatever = Whatever, table2.whateveer = Whatever [/code] is there a way to do this with the DELETE function [code] DELETE table1 INNER JOIN …

hai friend's i am having a table in that i have the field like ( id , name , date),in that i stored id name date e123 raj 12/08/2009 e123 raj 12/10/2009 e123 raj 12/12/2009 e124 ram 12/08/2009 like this while fetching the select id ,name,date from tablename where id="@id" …

I need some help with this small php search script, I have a small HTML form... [CODE] <form action="search.php" method="post"> <input type="text" name="search"><br> <input type="submit" value="Search"> </form>[/CODE] What they will do is enter a username and what I am trying to get is information based on that username displayed in …

hi.. i am newbie on learning web dev and still find the best resource for my study .. can anybody give a mysql manual that contains all mysql syntax and the syntax usability :) thanks all, please reply

Hi, Assume, I have table which consists of 5 values, say C:/Testing/test1/ C:/Testing/test1/test2/ C:/Testing/1/ C:/Testing/ C:/1/ I want to query the database table to get the values starts from 'C:/Testing/' and '/' as a escape character. ie, I want to get only two things, C:/Testing/test1/ C:/Testing/1/ Both starts with 'C:/Testing/' …

Hi All I'm new to this forum and i would be really greatful if I could get some help! Someone I know has his own tuition school and I must develop a website for him and I dont know lot about anythng to be honest. Not a great programmer or …

Right, I poster earlier with a practice table I was working on. I appreciated the reply and have been working on that.. but yesterday I got a real client's project. I have been given the task of optimizing the database design. The database keeps track of the transactions the company …

Hello, I am designing School Management System. I dont know how to design database for this. My Application contains 5 parts. Student Teacher Parent Data Entry Admin I need to maintain the following records. And these are not fields and i need all these for the particular page. Register (UserName,Password,SecurityQuestion,SecurityAnswer …

I have a database created in Microsoft SQL 2000 Enterprise Manager. I need to change the datatype for a column name EngrMultiplier in the table ProjectReCapParameter. The current datatype is INT and I would like to replace it to FLOAT. What should I do? Write a query or change the …

This code demonstrates how age might be calculated and filtered using the DateDiff method in SQL. Also, note that both the parameters are set to NULL by default, hence making them 'optional' to a certain limit.

I have a users table that has a table titled 'DOB', of format DateTime in MSSQL. Now, I would like to filter rows for all users who are over 30. till now i used this code: [CODE=SQL] SELECT * FROM [User] WHERE [User].DOB > = DATEADD(YEAR, @ageFrom, GetDate()) [/CODE] this …

i have 2 database & need some code to solve this problem. table 1 (food_place) : fp_id | fp_name 1 | McD 2 | Burger King 3 | Pizza Hut -------------------------------------------- table 2 (promo) : p_id | p_name | p_pid 1 | Disc.10% | 1 2 | Free f. fries …

How Many Databases are there? I know some of the databases, but i want to know many more databases, & what are they?

Hey guys! I seem to be posting here a lot the past few days but as I am new to SQL Server I am finding to quite a pain to get used to! I am having a problem referencing foreign keys. I did post another thread about this but this …

can anybody tell me oracle 9i download link.

Hi all, I'm trying to write query in MSSQL which will return a single value, but the problem is, I want to get the result by a position in results, e.g. [code=sql]SELECT [ID] FROM dbo.Users WHERE Status = 1[/code] -- and then some code to get let's say fifth record …

I have two servers and one of them have mysql db and one doesnt so is it possible to use mysql db in my other server while hosting my website on another. also if there is how would you do it with php.

Dear members I have a challange. I want to update my CRM database (MSSQL) with turnover numbers from our ERP database. I can retreive the data in different file types from my ERP database so they can be importet as a flat file. But does anybody have a good idea …

Hello, I have been looking for a data integration / transfer program able to help with Access. I have had some advice but have not found the right software yet. The main feature is being able to migrate important quantities of contacts and data on a daily basis. The migration …

this is not a web design question, i'm actually using it in vb.net but they don't have a database forum in the software development section. what i am doing: i have two tables. customer and customer_phones my visual basic program has a search for customer option, which returns the customers …

So I didn't know where to put this but I had somewhat of a newbie question. I am trying to create a blog for my friend. Its going to be a full fledged site and I want to store the blogs and be able to search on them later. I …

Can anyone tell me the difference between Truncate and delete Command .Kindly let me know the idea.Any help would be highly appreciated.

Hi, I need some help searching for extended ascii characters. I keep track of scores for a game along with the user's name. The user can have a crazy name like "»LPk«FËNÎX§" but when he searches for himself it isnt found so he has to search for something like lpk% …

im looking to convert this code using prepared statments if possible but am open to suggestions [CODE=php] function list_owner_notes(){ $id = $this->id; $sql = "SELECT nid, title FROM notes JOIN hubs ON notes.hub_url=hubs.hub_url WHERE owner = '$id'"; $result = mysql_query($sql) or die(mysql_error()); $notes = array(); / for($i=0; $row = mysql_fetch_array($result, …

Hi everybody I have been using mysqldump utility to dump the contents of database to a file. Everything is ok but i want to eliminate the "USE `db_name`;" statement that appears in mysqldump. Is it possible to do that. Please help:sweat:

Currently our database is set to case-insensitive so when I search for the word "Math" I can get "MATH" or "Math" and even "math". Now I would like to run a script that searches for any word that is the lower case form such as "math" or "science". Since the …

Hi, I am using MySQL Version 5.0.45. I am getting time out error while trying to access large data. I am performing 2 operations: a) I am loading the data file into the database b) I am retrieving the data from the database. 1) Loading the data file into the …

Hi, I need help with the following; Table 1 --------- Col A 1 2 3 4 5 Table 2 --------- Col A ColB 1 AA 2 BB 3 CC 4 DD 5 EE I need to look up say Table 1 Row 3, reference that to 'Table 2' but instead …

What I need is the SQL code to display the last business day - usually will be one day prior, but I want that if I run this code on Monday that, instead of Sunday's date, I get Friday's date. This is what I started with [CODE] - Automatically generate …

Hi how do i call a pdf file from a form in ms access please ?

Hi, I was wondering if it was possible to update the value of a mySQL cell by a method similar to using += in php code. For example, I'd like to do: [code] $sql = "UPDATE inventory WHERE userID = '$_SESSION[userID]' SET money+='$ssmoney'"; [/code] I know I can instead run …

Hello sir, I am creating student attendance tracking system in asp.net. With attendance i need to track students attendance every day and want to generate charts with those data. Charts for Daily Attendance report, Weekly Report, and monthly Report. For this how to design database in msaccess?

Please see and find out what was the problem. It's seem OK on me but it doesn't work on vb code using SQL Server 2000 [code=sql]"SELECT qry_close_month.Item_code, T_ITEM.item_name, " & _ "Sum(IIf(qry_close_month.Bulan='January',qry_close_month.Stock,0)) AS Jan, " & _ "Sum(IIf(qry_close_month.Bulan='February',qry_close_month.Stock,0)) AS Feb, " & _ "Sum(IIf(qry_close_month.Bulan='March',qry_close_month.Stock,0)) AS Mar, " & _ "Sum(IIf(qry_close_month.Bulan='April',qry_close_month.Stock,0)) …

Hello, I have a big web-site(ASP.NET) with a huge data-base(MS-SQL) and i searched for a good way to use paging in my web-site. I found two good way's to do it but i have a little problem to decide which paging way to use, [U]The first way to is to …

First off I apologize for being a newbie to MySQL but one must learn somewhere... I am attempting to create a stored procedure that take input (primary key) and finds a field for that record and output to a variable... my code so far: [CODE]CREATE PROCEDURE sp_dealer_name( IN dealerID CHAR, …

Hello, I have been checking for data integration / transfer programs able to help with Mysql. I have had some advice from some people but have not found the right software yet. The main feature would be to be able to migrate important quantities of contacts and data every day. …

Hello, I have a 4 GB DB on SQL 2005 and the same on on sql 2008 that is growing 60MB per day, My concern is that should i allocate an unused space to the DB so that the DB wont create space for itself everyday (load on the server), …

I am using this insert statement - [code=sql] INSERT INTO `crispwer_unipro`.`users` ( `user_id` , `user_name` , `password` , `email` , `activationkey` , `status` , `fname` , `lname` , `dob` , `gender` , `course_id` , `college_id` , `city_id` ) VALUES ( '2', 'k', 'k', 'kk@gmail.com', '', 'activated', 'keval', 'kothari', '2009-12-27', 'M', …

When I try to use MS SQL Server Enterprise Manager to create table, I typed column name, data type as "int", however the length of "int" is 4, that is fixed I cannot change, now the problem is I need to use this column as record ID, my database is …