Databases Forum

Hi, i am trying to come up with a schema for a databaes. It's been a while since I have done normalization on a schema, so I could use some help. Situation: There are boats. A boat is build in a shipyard. A shipyard has an owner. A boat is …

Hi, I am a bit confused and wish to share this with you for help. We are designing a billing application to bill telephone calls. It currently handles a single rate plan. So what it does is that it looks up the RATES table and matches the called number area …

Dear Friend I am trying to perform the flowing tasks using the following SQL statement in Microsoft Access but they don’t work. I wonder if someone could help and tell me what is wrong with my Statements. Whenever I run these statements it will not create the query. [B]Task 1: …

Dear Friends I am relatively new to Microsoft Access and I have to create a report to perform below task, any suggestion, comment and advice will be really appreciated. Task 1: Prepare an order as a report (similar to the attached order form) to show an order for a customer …

Hi. I want to know how it is possible to write your own function "UDF" in MySQL? and how use that UDF in MySQL?

I am using SQL Server 2005, I have some select and update statements in my query with WHERE clause I want to prevent these queries from SQL injection attacks. What are the steps and precautions to be taken for SQL Injection attacks? Does anybody have suggestions? Thanks in advance,

Hi guys I am currently revising but I am having difficulty normalizing the project table below. I can achieve first normal form. but when I try to normalize to work out 2nf I get confused. The table does not come out clearly below so I have attaced a word document …

I am quite comfortable with MS Access and have developed a complex relational database for my company. However, we have decided to use FileMaker 9 as our database development software, so I have been asked to re-create this same databse in Filemaker. I am finding it difficult, as the simple …

I am new to FileMaker Pro 9 and have used MS Access a little. I am wondering if it is possible to transfer files from FileMaker Pro 9 (many files) to a web MS ACCESS database where another company where we send our data?

Ok so i have an interesting problem i need some help with. I am a beginner/intermediate user of FileMaker Pro 9 and i maintain a database that contains scanned in files. I am trying to automate the scanning/record making process but to do this i need FileMaker to pull the …

Hello, i have a database that came with MYSQL statements to get it working but we are using MSSQL and have managed to convert a large proportion of them but there are two statements we are having trouble with and wondered if anyone could help. The first is below: [CODE]SELECT …

Hi, I am trying to install Oracle 9i but when it comes to Java Runtime Environment, it asks me path for it. I have JRE installed in my Computer. What else do i need to proceed this installation? Thanks

is it possible to add a number to a number that is stored in mysql db without extracting the stored number first. i have a count and i am updating the count periodically but i would like to know if i can update the count while it is in side …

after i have run my query on a mysql db how can i set the result to equal a variable that i will use later on in the page. i have set the query up like this [CODE] <?php $rand = rand (0, 100); $query = "SELECT broad1 FROM images_broad"; …

i have created a table to store the number of a count which i need for some subtraction at a later date. when i try to get the information out of the table instead of getting the number 5 i am getting resource id # 5. the table has been …

Hey guys, Is there any way that I can just simply get the length of a row in a table? Thanks

In the expression IIF[SSN]=50,99,[SSN]) when I enter 60, all works well. But if I enter 50, I get "The value entered doesn't meet the validation rule for the field or control". BTW, SSN is defined in the table as Number (Long Integer). What's the problem?

Hi, I wan to know where the MySQL variables stored? when I execute the [CODE]show variables; show status; [/CODE] I see many more variables, so I want to know the place they are stored in? and the file name too?

I use MS Sql Manager 2008. I need to extract some diagrams from my database. I tried to use reverse engineering in Visio but there is some problem with compatibility Visio drivers with my DB. Have any idea how to set up this and get the diagram(s)? Anyway I found …

hi ... Need help i need code for backup a database.. i want to place the code in a button...

hello, i'm fairly new to oracle, but i pretty much get it. anyway i've created a table using this code : [CODE]create table BanquetReservation( ResNo SMALLINT NOT NULL, Restriction varchar(30) not null, ResType varchar(10) not null, DateOfEvent Date not null, NoOfPeople SMALLINT NOT NULL, EndDate Date, StartDate Date, SSN CHAR(9) …

Hi. Can anyone tell me how to create a mobile database and application using SQL Server Management Studio Express?

Hi. Now to start with I'm not asking you to provide me with a solid answer to this, but enough information so that I know where to start looking would be good. I have a project that I am working on which is an Olympic Database. I have several tables …

Hi, I need to match rows from one table to another table that may or may not have a match on one common column.... the problem begins with bringing back the most recent row in the other table. So, the query I'm starting with is: [code]SELECT * FROM data LEFT …

Hey All! I'm currently creating a database for a payroll system. I have a table consisting of Occupation_ID (primary key), occupation_description, normal_rate and then 3 different overtime rates. I've created a query to calculate the overtime rates for the different overtime rates, i.e. [code]UPDATE Occupation_Rates_Table SET occupation_rate_overtime_1 = Occupation_Rate_normal*1; [/code] …

Hi. I want to GRANT privileges on two tables, but I dont know why error, but on one table it is ok. what is wrong? [CODE]GRANT SELECT ON mysql.db, mysql.user TO 'user'@'localhost' IDENTIFIED BY 'password';[/CODE] I dont know why it is not working on two tables???

I'm getting this error message [B]An exception occured while executing a Transact-SQL statement or batch (Microsoft.SqlServer.Express.ConnectionInfo) CREATE DATABASE permission denied in database 'master'. (Microsoft SQL Server, Error:262)[/B] When I try to create a new database from the right click option on the master DB. I think this is a permission …

i have to get days of that particular month , that is if i give dates between different months like ex: 25-FEB-2008 and 05-MAR-2008 in this i want get 5 days only not 10 days

After creating the table i tried to specify the unique key constraint in sql server 2005 but its asking for the expression. I don't know what to give in that expression. can u please help me out in this. thanx in advance.

Hi, I have a question pls clarify it. If a table is created and grant, index, triggers, synonyms etc are defined on the table. what happens to grant, index, triggers, synonyms etc if the table is dropped. What is the data dictionary needs to be checked to validate all these …

Hi, I have a question. Please help me out. What is the default "display date format" and default internal "accepting date format"? How to change the default display and accepting format. In my system, the default display date format in sql * plus is dd-mon-yy, where as in toad it …

Hey guys, I'm working with a database at the minute (not my own), and the two tables are as follows: ---------------------- Customer ---------------------- CustomerID Agent 1 55a 2 97t 3 87f 4 44g 5 63l 6 21s ---------------------- ----------------------------------- Details ----------------------------------- ID DetailName DetailValue 1 FirstName John 1 LastName Smith …

I currently have a database that is just one table with products and is using the myisam engine for the fulltext capabilities on two columns. The question I have is that this database has about 390,000 rows with a lot of duplicate entries namely manufacturer, price. I have been searching …

Help! I can't get in to Access 2007. It's not a database password, but an password for Access itself. I can't even create a blank database. All it does is prompt me for a username and password. I've tried all 10 usernames and passwords of mind but they don't work. …

Hi all, I wonder if it is possible that someone can drop me a code or something on this particular problem which I am currently dealing with. in_date out_date 18/03 30/04 20/04 So how am i supposed to pair up 30/04 and 20/04 as 1 pair and show it up …

if i use the query [CODE]SELECT iditem, CONVERT(char(20), dt, 105) FROM planeamento[/CODE] it works just fine.. but in this case the dt (date) field is not recognised.. [CODE]SELECT planeamento.iditem, idmodelo, item_planeamento.idproduto, item_planeamento.idpele, cor, ordemfabrico, qtd, CONVERT(char(20), dt, 105) FROM produto INNER JOIN item_planeamento ON produto.idproduto = item_planeamento.idproduto INNER JOIN planeamento …

Ok , maybe i should explain this.... logically i have a form , where i have a drop down list , which lists fields on a table those fields have records on the table, i want to automatically display those records for each field on the form , when you …

Hi people. This is my first thread, i hope you can help me. I'm a newbie and my english is so bad, but, i hope you can understand me. this is my question: I've a table TURN with this field IDTURN (int) SEASON (string) SORT (string) another table GROUP IDGROUP …

Hi I created an DB, that export data to Excel and create a chart from this data, now I want to know, what can I do to filter data and set a criteria eg. A$2:D$46-range, Criteria =2. The filter is not working if I set that critria, for the data …

Hello, We are working on a project in which there will be multiple online shops, each "owned" and managed by different clients. The shops will be similar in nature (mostly identical) but each containing its own, unique data. Data would not, in principle, be shared by different clients. At this …

Hey, could use a little help here. I must be brain dead but I can't think at all, I need help. I have a table with a bunch of IP addresses in it and a lot of them are the same, how do I -- Remove all the IP's except …

Hi Guys, I was just wondering if there's a way of restricting access to the contents of a database by creating a list of users and their corresponding password. So when ever someone tries to open the database a form pops up asking for their user name and password. Thank …

Hi everyone, Ima working on a business site similar to alibaba.com.In that we have a main categories named agriculture,chemicals ....so on. on clicking on agriculture we get one more subcategory containing different names line plant products,beans so on.. on clicking on beans we get the companies selling beans. similar to …

I've fired a query which result some data with the respective count from the table and after that i want to fire a query to get the total number of count on that count which i got it from my first query. Could anyone helps me out to get the …

I have the problem of splitting the the table into following way. Pl help me in doing it Actual table Product Id ProductQty CompCapacity 1 8000 5000 2 10000 5000 4000 4000 Resultant table Product Id ProductQty CompCapacity 2 5000 5000 2 5000 5000 1 4000 4000 1 4000 4000

Hie there what does it stand for abbreviation

hi all, Is there a code where i can check from all the existing tables if a certain variables exist in it? I am currently working on a project but the tables are not linked properly, having a hard time trying to find out how many tables actually have the …

Hi All, SELECT * FROM Results WHERE ActualValue NOT BETWEEN Lowerimit AND UpperLimit In my query ActualValue is VARCHAR field. How can I get Results that are out of limit? Shrinivas

Here is the code. For a short time, I will leave the test results up at [URL="http://superiorminitrucks.com/inventory"]superiorminitrucks.com/inventory[/URL] Clearly, I need to stop it from displaying the final entry twice.. Thanks in advance.. [CODE] <?php $db_connection = @mysql_connect("######", "#####", "####"); if (!$db_connection) exit(); mysql_select_db("tefflox", $db_connection); $result = mysql_query("SELECT * FROM trucks"); …

Okay I have a database that contains records of billing information. I have created the queries I need to display the information but my issue is, is there a way to take the total values that are being produced from the query and separating them depending on amount for instance …