Databases Forum

HI TO ALL, I get this error:[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.When Running my vb6 module on Another server SQL Server is installed on Windows Server 2003,and i am testing the application from WinXP and Win7 on my server it will work. Testing from other machines(Server) with …

Hi, Im trying to get the depreciation value of an equipment every month. My system gets the number of months from date of purchased up to current date for the computation of depreciation. I can run the report anytime but the computation must be like this: Sample: Date purchased January …

Hi All, I am wanting to round up my values at query time to 0 decimal places from 2 decimal places. I have SELECT DISTINCT b.vSeries_Table_Number, b.vSeries_Number, b.vSeries_Geography, b.vSeries_Type, b.vSeries_Unit_Type, a.Variable_Date, ROUND(a.Variable_Value, 0) AS 'Value' but the output still has the 2 decimal places which are 0s and pointless in …

Hi i have a query that i want to display the pulser1 pulser2 pulser3 pulser4 from table but only when the input type for each pulser=2 when i run the query not working as i want it please check my query $netw is a variable it can be any value …

hi i am writing a report, it must have parameters ToDate and FromDate,now the thing is i did all that but it stllrespond with just headring no data. Please help what am i doing wrong

Hi, I want users on my website to upload their company logo (if they have one) while filling out my form. Right now i only have one row designated for the company logo called 'images' with the type set to BLOB. Is this adequate for both uploading images and displaying …

I want to make the closing balance of the current month lets say of March to be the opening balance of April in sql or crystal reports how to i go about it. Help need the solution agently please. the script below is the one i have used to get …

I am new in using MySQL database and need some help. The scenario is pretty much like this: I collect data from some sensor which come with their own software. The software builds a .db file as it takes data from the sensors and saves it locally in the computer. …

Hi All, I'm having a go at SQL queries and have the following: SELECT b.vSeries_Table_Number, b.vSeries_Number, b.vSeries_Geography, b.vSeries_Type,b.vSeries_Unit_Type, a.Variable_Date, a.Variable_Value FROM tblPopulationSC AS a INNER JOIN tblVSeriesList AS b ON a.vSeries_ID = b.vSeries_ID and b.vSeries_Geography='Manitoba' --and b.vSeries_Unit_Type=' 15 to 64 years' and b.vSeries_Type=' Both sexes' and b.vSeries_Unit_Type=' 65 years and …

hi what is the query to fetch duplicate records in oracle table.

Hi all, I've been looking into NoSQL (particularily MangoDB) and am liking what I see. I have one clarification though: If I'm gathering data about a particular "thing" on a daily basis, should I have one document per "thing" and add the new data to it every day? Or should …

Hello, I had a very peculiar problem today which I am sure hundreds would have had and solved before. I have developed a VB.Net + SQL Server application and installed it in a few dozen places. All worked very well. Then I installed it in a persons computer in Middle …

Bear with me please because my SQL is not that good. I want to write a query that takes into consideration information from 3 different tables. Let me explain the situation: When a customer books a room, they have the preference of several rooms and the rooms can be booked …

How to delete duplicate record in sql serer plz suggest me............ thanks

Good Morning. I am writing a little function to record the visits to a landing page, and want to do it in such a way as to not count multiple visits from the same IP address within a 24 hour period. What I was wondering is if there is a …

Hi all. I'm developing a quiz application consisting of multiple choice questions. Here are the tables that I've come up with. CREATE TABLE IF NOT EXISTS `student` ( `s_id` int(10) NOT NULL, `s_name` varchar(30) NOT NULL, `s_email` varchar(30) NOT NULL, PRIMARY KEY (`s_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; CREATE TABLE IF …

Status field contains values Open,Awaiting,Approved,Rejected. To store a value what is the best datatype in mysql? Is it TINYINT OR VARCHAR? TINYINT occupies less memory if we store numbers instead of strings ( 1 => Open, 2 => Awaiting ...). Is it cause any performence issue when using joins? I …

I want to have the following on SQL Azure: IF EXISTS(SELECT * FROM [sys].[databases] WHERE [name] = db_name() AND [compatibility_level] = 110) BEGIN ALTER PROCEDURE [dbo].[Test] AS BEGIN -- Omitted body containing lots of strings END END or a work-around that does something similar. What follows is what I'm trying …

Hello all: I would like to query my mysql table for a total number of records inserted during a specified day of the week within a specified time period. More clearly: count number records inserted on Tuesdays during the time period of 2013-01-31 - 2013-02-03. The first day of the …

HI Friends, SQL> edit; SP2-0110: Cannot create save file "afiedt.buf" how to fix this problem.

Sirs, please suggest a good way to handle large amount of data. This is my newbie idea: - create a database on one of high powered pc(dedicated for whole company) - then sync every changes to another copy of this database to the online hosting service with security note: theres …

Hi all. I hope I chose the forum to post in, it's an in between kind of question. I'm looking into options to develop my final year project. It's a formative assessment of a theoretical course to grasp students' understanding. The focus is on the ability of students to relate …

If I have relation schema R(A, B, C, D, E) with functional dependencies: AB->C, CD->E, C->A, E->D: a)find all the (minimal) keys for R b)state the normal form for R and describe functional dependencies that violate higher NF c)decompose R into 2 (or more) relations that are in highest possible …

Hello, we are saving in the database time as our local time which is UTC+2 How to convert to other times? I found in that this should work: select sell_date, sell_date at time zone 'UTC+2' as UTC2 FROM cards order by id desc limit 1 This sql should return same …

I have quiz ID(Q1 for example) and below is the number of items in that quiz. My problem is, I need to display a dash when query cannot find a record in my database, if there is a record it will show up and the missing records will be filled …

I try in psql shell pg_dump --schema-only but is is doing nothing after hitting enter it just shows glab-> why is that? I tried adding ';' at the end of line - still the same. But before it there is glab=> so one char differs. Why is that? also is …

I have four memcached servers, 2 GB each. Each one averages about 1 set operation per second, and 500 get operations per second. However, the hit rate is incredibly low at only about 45%. Is this still efficient considering that, even taking into consideration only half of the get operations …

Hi, I have to draw an ER diagram for assigning classrooms for scheduled courses for university. A classrom is simply a room within a particular building and all bulidings on campus have atleast one classroom. A classroom is scheduled for a particular time and day or days of a week. …

If I have relation schema R(A, B, C, D, E) with functional dependencies: AB->C, CD->E, C->A, E->D: a)find all the (minimal) keys for R b)state the normal form for R and describe functional dependencies that violate higher NF c)decompose R into 2 (or more) relations that are in highest possible …

I'm trying to get an xml file from an ftp and then insert select data into mysql db. I'm shooting in the dark but from googling this is what i've tried so far: $curl = curl_init(); $file = fopen("import.xml", 'w'); curl_setopt($curl, CURLOPT_URL, "ftp://company@company.company.se/company/import.xml"); #input curl_setopt($curl, CURLOPT_FILE, $file); #output curl_setopt($curl, CURLOPT_USERPWD, …

Hi, I, getting a new xml file everyday to one of our external ftp servers. I want to get that file and then insert select data into my mysql. What I'm thinking is that I would use curl to get the file, then simplexml and then insert into database. But …

Hi, I'm making a webpage where it allows users to online book like let's say on a hotel, how do I show the users on the site the unfilled slots (dates and time) on the database? I'm using MS Access.

Hi everyone, I need suggestions. A little corporate needs to track its data with 2-3 employees making a daily data entry/updating of few records (20-30). Data must be available to other employees. They want to store data in a SQL Server db that has been already implemented. The whole db …

hi there. I have a problem in making my amortization. I just only want to know how to change data grid view's command text with where conditions. this what i've got: LoanSampleDBDataSetTableAdapters.loan1TableAdapter.commandText = "Select * from Employees where ID =" & n1 Then error occurs.

I dont guess anyone could help me out on setting up my products tables could they? I did search and read through these posts: http://www.daniweb.com/web-development/databases/threads/123850/e-commerce-data-design-issue http://www.daniweb.com/web-development/databases/threads/132796/database-schema-for-a-store But I'm still not sure, Currently my site will only have 3 separate products, each with their own set of attributes. How should I …

hiii, i am executing the following stored procedure but having errors... create procedure check_returns @salesman varchar(10),@RCV10 int,@RCV09 int,@RCV15 int,@GPRS15 int,@RCV20 int,@RCV25FTT int,@RCV25 int,@RCV31 int,@RCV30 int,@RCV35 int,@RCV50 int,@RCV55 int,@SIM int,@VTOPSIM int,@VTOPBAL int,@THREEGSIM int, @ENTRYDATE datetime AS BEGIN if exists(select * from CardsIssued where salesman=@salesman and RCV10>@RCV10 AND RCV09>@RCV09 AND RCV15>@RCV15 AND …

I have a client who deleted users on his database. Is there any possibility that the records have been flagged for deletion rather than physically deleted? If so how do I recover them? It's a Joomla system and there are no backups. Thanks. (Yes, I know).

Hi guys, I have a database with hundreds of persons and doing a live-search with ajax. And I have this query. The idea is that I do have the test line in the db but it has a status 0, but it is keep showing up in the results even …

hiii, i am executing the following stored procedure but having errors... create procedure check_returns @salesman varchar(10),@RCV10 int,@RCV09 int,@RCV15 int,@GPRS15 int,@RCV20 int,@RCV25FTT int,@RCV25 int,@RCV31 int,@RCV30 int,@RCV35 int,@RCV50 int,@RCV55 int,@SIM int,@VTOPSIM int,@VTOPBAL int,@THREEGSIM int, @ENTRYDATE datetime AS BEGIN if exists(select * from CardsIssued where salesman=@salesman and RCV10>@RCV10 AND RCV09>@RCV09 AND RCV15>@RCV15 AND …

I have a table of withdrawal requests that has a datetime field called 'create_date' I need to query that table to see if a member has submitted a withdrawal request within the past 24 hours If they have, I need just the most recent record within 24 hours that matches …

In my MySQL database I have my regular tables, and a couple of VIEWS. Everything runs like clockwork, until I remove Remote Access to the database. I cannot access any of my VIEWS. Accessing any regular tables still work 100%. The thing is, the PHP script accessing the VIEW is …

hi there.. I just need some help for my loan management system. thus anyone know how can i stored schedule of amortization to the sql serve? is it 1 insert statement is enough to store in database? do this problem need looping. I don't know what code should I need …

SELECT DISTINCT course.course_no, description FROM course, section WHERE location = 'L210' ORDER BY course_no Here is the problem: Give me a list of courses (by course_no and description) that are taught in room L210 But now find out I need to use the JOIN...ON... syntax Need help redoing that with …

hi, i am adding in a basic accounts table to my system. what i need to know is what is the best way to insert repeat payments. such as rent monthly? many thanks

1. Can ZoDB replace MySQl or both of them serve different purposes? 2. If yes, is ZoDB as good as MySQL for handling a dynamic website?

I have an sql code that is retreiving a row with more than one line, Is there a way to make it combine those two lines into one line. select revertrsn from LN08PENm where aano in(754,870,1136,1138,1139,1140) the data coming in the row that I am retreiving is like this: As …

Hi guys, I'm working on a holiday scheduling app and I was wondering that if a person wants his holiday for example 10 days. id uid data1 data2 ore tip_concediu ts 7 244 2013-01-25 2013-02-05 3 2 2013-01-25 16:08:35 How would it be possible that I could track the holiday …

hi, i have looked on net all over and cannot find an occupations table. basically for my application i need a table of occupations so if anyone has this in sql or excel please can you post up here? many thanks

Hi there, Can someone tell me how do i upload the data created in mysql command line client into the Mysql server, I mean, i have created some tables using mysql command line client in my system, it is accessible only to me. How do i upload it into the …

Hi everyone, Ok so let me start by saying I am COMPLETELY new with MySQL, I have only tried to use it for the first time hours ago. This might be an easy one for you guys... Here's my code: <?php // Grab User submitted information $email = $_POST['users_email']; $pass …