7,494 Archived Topics
Remove Filter  | |
| | Hi all, I am fighting with this a while allready, a moving average with mutilty items The (example) tabel : item datum volume item1 1/1/2009 10 item1 1/2/2009 11 item1 1/3/2009 12 item1 1/4/2009 11 item1 1/5/2009 10 item1 1/6/2009 10 item1 1/7/2009 10 When i do this with only … Databases mysql |
| | hello everyone i am currently working on a php script on my website. I wanted to make a script for registering users. So that they may log in, log out, register, and access member only functions. I found a good tutorial online but since im fairly new to php and … |
| | I'm designing a database model for a Gallery. Never done Normalization before, I did some research online and came up with these rules, followed it and this is what I came up with. Trying to get to from UNF to 3NF. Are these stages correct? or am I way off... … Databases |
| | Hi everyone Hopefully I can describe this issue properly. For ease I'm going to use a hypothetical situation. Lets say I'm working on a program that tracks the number of times 2 employees have worked together. Here's a week example: Mon - Tom, Bob, Al Tue - Tom, Al, Cindy … Databases  |
| | Hi all! I can code queries well, but not confident with designing and normalization skills as yet. I wanted some advice on how you would go about putting together a db to house just this data. I'd like to see it in 3NF. The cranes move, so start date and … Databases |
| | I got referee and project as two of my tables need help finding other based on this and know what kind of relationship it is and what the assumptions are. Leeds Met students and staff have the opportunity to volunteer on community and conservation projects at home and abroad. Projects … Databases |
| | Hello, What SQL query should I use, in order to copy records from one table to another, both of the same schemas, in such way that only records that don’t already exist in the destination table will be copied? For example: Table A – Destination table ****** Col1 Col2 Col3 … Databases mssql |
| | I'm a noob and am struggling with what should be some fairly straightforward php and mysql coding. I have a page that I am building and am able to get the following code to work: [code=php]<?php include 'includes/config.php'; include 'includes/opendb.php'; ?> <div align="center"><h1> <?php $id=$_GET['player_id']; ?> <? $query= "SELECT p.player_id … |
| | hi, I have implemented the following query to search the db for exact phrase (ex : if the search term is "air" should match the exact word not like hair). Quote: [code=sql]select A.*, B.*,C.GGCategoryID,C.CategoryName,C.CategorySlugName,XX.EcoStatus from tbl_products A,tbl_members B,tbl_product_categories C ,tbl_eco_ratings XX WHERE A.MerchantMemberID=B.MemberID and B.MemberType='Merchant' and A.GGCategoryID=C.GGCategoryID and XX.EcoStatusValue=A.EcoStatusValue and … Databases mysql |
| | We have a Log table which logs the events of a request. When any error event occurs, I need a query to see the row with errorevent and the previous row to this row which contains the actual data which caused the error. Here is the table structure: LOGID (int), … Databases data-structure mssql |
| | hi i had a database table and one of its column is filled with hobbies of the users. ( eg: stampcollection, fishing, photography ). How to do a search in this column. I am using php. If visitor search by any hobby then need to show users in database who … Databases mysql |
| | Hi All, I am trying to build an SQL statement that will pull data from a parent table and count rows in a child table. Parent table - event: [CODE] eventid, title 1 'Metallica is coming' 2 'Elvis is in town' [/CODE] Child table - eventattendance: [CODE] eventid, userid, response … |
 | Hello all, Are UDFs written only on SQL Analyser in within the SQL? Can we use them in programming code?How to use them in the code? What are the actual benefits of UDFs? We can write the method in the code and connect to the database and execute which yeilds … Databases mssql |
| | I have a program that uses a Stored Procedure to create a report. Unfortunatly the SP has a problem in the VB6 code. The program could pull the information perfectly until 2 days ago. Now the program times out after 60 seconds after sending the params to the sp. I … |
| | Hi All, I've a table name Countries with two fields as ID, and CountryName. Where ID is foreign key(ie., may have duplications) and the country name can be repeated as many times as it needed. for example the scenario is ID CountryName 1 India 1 US 1 UK 1 Japan … Databases mssql |
| | Need your help:) Got the following problem: A French vocable got one or more English vocable equivalents and vice versa. What is the best way to store these information in table(s)? Thanks for your help in advance. Best regards, DBGuy007 Databases |
| | Hey all, I need help from all you genuises out here. I have 3 tables [CODE]CREATE TABLE IF NOT EXISTS `tags` ( `id` int(11) NOT NULL AUTO_INCREMENT, `tag_name` varchar(255) NOT NULL DEFAULT '', PRIMARY KEY (`tag_id`) ) CREATE TABLE IF NOT EXISTS `video_posts` ( `id` int(11) NOT NULL AUTO_INCREMENT, `title` … Databases mssql |
 | |
| | trying to extract fulladdress to individual column such as address1 address2 City State Zip, and each of the fulladdress has a [B][U]comma[/U] [/B] so that why I am trying to create a function that count the comma and put the fulladdress ito individual column. hear is the script that I … Databases mssql |
| | Hi people... I have phpVideoSearch script, and want to add a feature, that if someone a specified page, to add to mysql a +1 value... Example this is the page: [CODE]watch.php?title=Riz+Khan&link=http://www.youtube.com/v/[B]xE0wOa5R6KY[/B][/CODE] i've set a code to create a id for this video like: [B]yt_xE0wOa5R6KY[/B] Can someone help me create a … |
 | Can someone help me with this database, code bellow [CODE]-- -- Table structure for table `bapps` -- CREATE TABLE `bapps` ( `bappID` int(11) NOT NULL auto_increment, `bappFROM` int(11) NOT NULL default '0', `bappBUSINESS` int(11) NOT NULL default '0', `bappTEXT` varchar(255) NOT NULL default '', PRIMARY KEY (`bappID`) ) ENGINE=MyISAM AUTO_INCREMENT=51 … Databases data-structure mysql |
| | Hi. I have this problem Group by will make the table only show a value of that group once. So lets say there was 1000 results without group by. 500 with a single group by. But now i want to do another group by to filter it down more to … Databases mysql |
| | Hello all, using mysql I have the folowing (example) table +------------+--------+ | date | total | +------------+--------+ | 2009-01-08 | 150000 | | 2009-01-09 | 151000 | | 2009-01-10 | 156000 | | 2009-01-11 | 154000 | | 2009-01-12 | 153000 | | 2009-01-13 | 157000 | +------------+--------+ Now i … Databases mysql |
| | Hi, I am wondering is there a solution to do this type of problem. I would want to release a list of queries that only show only orders that does not match each other. For a order to match it will be companyname from different hiddenkey are the same and … Databases mysql |
| | hi All, I want to ask if is there any possibility to separate column data in different columns using php code.. really dont know if i have solution in php or here in mysql.. any idea would be really appreciate Thanx enim Databases mysql |
| | Hi, I don't know why the server I recently get to manage, has the SQL Server 2005 installed but with the Management Studio Express!... I need to upgrade it with the Dev version, but when I put the DVD of the SQL Server installer, It won't show my actual installation … |
| | Hi, I have 2 instances of SQL Server running on one machine (One 2K -default- and one 2K5), I have no problem connecting from a PC on LAN to the 2K5 instance, but when I try to connect to the 2K instance, it fails (it gives me an error: "Named … |
| | Hi all, I have a Stored Procedure without an output parameter but it returns one row always, this SP is called by another SP, so I need to store some of those columns in a variables of the first SP. How can I do that? Please help. P.D.: I have … Databases mssql |
| | I have two "entity" tables: Company and Agency. Both Company and Agency can have multiple addresses (shipping, billing, etc.) and multiple contacts with titles (president, sales rep, etc.). Rather then put address and contact information in each entity table, I want to create a table that is common to both … Databases |
| | Hi everybody, I've got a big pb, and I need help..... I have to use MS SQL Server 2005 SP2 Enterprise Edition instead of MSSQL Server 2000 Enterprise Edution and I don't know how to use the old SQL 2000 db. Any sugestions? Thanks for your time. Eddysonys |
| | Hi..I am fairly new to SQL and need some help writing a script. I have 2 tables table 1 is the student data and table 2 is the student schedule data. In table 2 the students have a student id number that is teh same as the student id in … |
| | Hello, I have two tables, one with the main users details in and a users movement table which has an entry to everything they do. I want to pull out a list of all users which havent done a specific task, put only pull the results once. So for example … Databases mysql |
| | We have an MS-Access DB that we would like to create emails from is that possible. Approx. 140 employees we like to create emails to from Access. Thanks for any pointers. Russ @ scaninc.org Databases microsoft-access |
| | I have a table with 32 fields. Is there a shorter way - [ other than select sum(field1 + field2 + ... Field32] to get the sum of all fields for a date range. I know, I know, once I create the query I can save it for future use … Databases mysql  |
 | i get this error:[quote]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'index, user_id, username, message) VALUES(' ', '4', 'zack', 'jh')' at line 1[/quote] [code]<?php session_start(); $_SESSION['user_id'] = 4; $user_id = $_SESSION['user_id']; $_SESSION['username'] = … Databases mysql |
| | Hi Mates, I will just get right down to it. If I have these Entities/Tables. 1 - Clients 2 - Cases 3 - Invoices Assuming all relationships are one-to-many. Which Figure is the right way. [ATTACH]8515[/ATTACH] Figure A - I can deduce which invoice is for which case, which case … Databases |
| | I wonder if someone can point me in the right direction for securing my site more effectively. Having experienced problems with Google warning pages being placed on my site relating to potential malware, I've been looking into "beefing up" security, but am find the tutorials relating to safeguarding against sql … |
| | Hi all, I have a customer table. Each customer can have multiple contacts, as well as multiple phone numbers. Each contact can also have multiple phone numbers. My design right now is as follows: [B]customer table:[/B] cust_id cust_name cust_address ... [B]customer contact table[/B] cust_contact_id cust_id (fk) -> refers to customer … Databases |
| | Hi folks, I want to access Oracle 9i table "emp" in Java... I do not know what driver to use .. The name of the Oracle database under which "emp" falls is "Oracledb" I do not know what the connection string is? Pls help... |
| | Hi all, I'm am still learning mysql so please excuse anything I may not understand. I need to update 12k records in a mysql table (about 5 fields per record) twice a day, and it needs to be done automatically (probably with curl). My data source is a comma delimited … Databases mysql |
 | Hello all, I'd like to know if there is a way to insert into a MYSQL table data in an ordered way? Right now as a workaround I've literally made a table of questions with questionID as primary key, nextQuestion and prevQuestion pointing to other questionIDs. Basically I've made a … Databases linked-list mysql |
| | hi, i had a mysql table and my friend make the database in excel file. Now I need to import my excel file into mysql table. Anyone help me how to do this ... Thanks in Advance Databases mysql  |
| | Hello everyone, At first, I would like to wish an happy new year for everyone. Now, my problem! I'm starting a new web app (which is the first one I will completely write) and after modeling the database, I encoutered a problem for adding datas in my category's table: [code]-- … Databases mysql |
 | [code] Apply all steps of conceptual and logical database design on the following requirements: The system should be able to store a customer’s name, address, and contact information and a book’s ISBN, publisher, authors, and title information. A customer should be able to purchase one or many books at a … Databases database-design |
| | Hi guys I was wondering, how to prove that your tables are in 1NF, 2NF and 3NF? Thanks. Databases |
| | Hi I am trying to insert data into 1 of my table and I get this error: Microsoft Access can't append all the records in the append query. Microsoft Access set 0 fields to Null due to type conversion failure, and it didn't add 1 records to the table due … Databases database-design microsoft-access |
| | To all fellow geeks and to whom have prior knowledge in database design, I'd like your consultation on several issues I've faced in my project. So first I'll give a brief explanation about the it: We are supposed to develop the following software: Semi Automated ER diagram generator [u]Input:[/u] Meta … Databases algorithm database-design engineering |
| | Hi, I am a technophobe in his last year of a business/computing degree. If someone gave me the db structure for my final year project interim report to be handed in tomorrow I will be forever grateful................ I am designing a website where people can search for spare car parts. … Databases |
| | Hi All, I have an association table with 3 columns (primarykeyId, foreign key to Table1, foreign key to Table2). I am thinking to have a child table pointing to this association table. The association table will have additions and deletions for new associations. Now the new child table will also … Databases |
| | Hi all, I am new to sql programming, How can we copy a database from a local system to server? Thanks in advance, karthik. Databases mssql |
The End.