7,494 Archived Topics
Remove Filter  | |
| | Hi. How could look database structure for callendar apllication with functionallity similar to Outlook Callendar? How single day should be stored in DB? regards q Databases |
| | In my MS SQL 2005 i have given "[B]Windows Authentication[/B]". Now how to connect with NETBEANS?? I means wat to give in User Name and Password fields?? I tried to give my User name and password while login into Windows. But not working. I am getting this error [COLOR="Red"]"the user … Databases mssql |
| | [code] <?php if (isset($_GET['id'])) { $id = abs((int)$_GET['id']); $sql = "SELECT *, ((`hit_head` + `hit_chest` + `hit_stomach` + `hit_leftarm` + `hit_rightarm` + `hit_leftleg` + `hit_rightleg`)/`shoot`) AS 'acc' FROM `zp_weapon_stat` WHERE`id_weapon` = $id"; $r = mysql_query($sql); $row = mysql_fetch_assoc($r); if ($row) { $template = 'weapon.xsl'; $weapon = $root->appendChild($data->createElement('weapon')); foreach ($row as … Databases mysql  |
| | Hi Im trying to pull out a list of meetings, and the associated number of comments attached to each meeting. Comments are assigned a category (ie meetings) and a linkid (the uniqe id of the meeting) - Im using this query, buts its cutting out all meetings that don't have … Databases mysql  |
| | I've got a situation with minibus repair database design, where it looks like in the Repair table I could do with a 3-composite primary key: jobID from the JobType table (types of maintenance with price and time), mechanicID (Mechanic table), minibusID(minibus table). This way, I've got type of job performed … Databases database-design mysql |
 | Despite having recently been [URL="http://www.daniweb.com/news/story273853.html"]cast as the villain of the piece[/URL] by some high profile members of the Free and Open Source Software community, IBM has just revealed itself as actually being something of a crime-fighting superhero. The Florida State Department of Juvenile Justice is following in the footsteps of … Databases abuse cybersecurity open-source peer-to-peer |
| | Ok, I'm new to php and MYSQL aswell. I have a couple programs actually that are getting this error and I don't see what could be causing this at all. Here's the situation. I have a job interview page. The user enters the information from the candidate and submits the … Databases mysql web-browser web-server |
| | Hi, I have a query: [CODE=sql]SELECT h.id, h.creator uid, h.haiku, h.title, h.likes, h.approved, cat.name category, count(c.id) comms, h.anonymous, CASE h.anonymous WHEN 1 THEN 'Anonymous' ELSE u.username END username FROM haiku h left join categories cat on cat.id= h.category left join comments c on c.haiku=h.id left join users u on u.id=h.creator … Databases mysql |
| | I'm making some dynamic drop down boxes for a site that get their contents from a database, i belive i have the correct code to do this [CODE]<?php echo "Product Code"; $sql = "SELECT DISTINCT Product_Code FROM product_supplier"; $result = mysql_query($sql, $odbc) or die("could not run"); echo"<select name = Product_Code>"; … Databases mysql |
| | ok, here's the thing: If I were to create a fileserver website like Microsofts SkyDrive then how should I structure the database? There are incredibly little information about database structure on the internet (web security too) and I've searched a whole lot. Should I create a table for every user … Databases |
| | |
| | I'm relatively new to access and have a problem. I have multiple rows of information on a form, and each of these rows has a few text boxes and one combo box. The combo box needs to have different information in it based on another field in the row. The … Databases microsoft-access  |
| | Hi, I'm trying to code a league table system and I was wondering if there's an easy way of doing this: [CODE]$result=mysql_query("UPDATE Championship SET played="++1" WHERE team_name='$home_team'") or die(mysql_error());[/CODE] The problem lies in the played="++1" part, I can set it to be any integer, but that's not much use, I … Databases mysql |
| | Hi Guys im trying to draw a erd with uml notation according to a case study, but im having difficulties as im a beginner. Case study: 1) A department have many employees, although each department must have at least three employees. Every employee works for one and only one department. … Databases |
| | Hello, I have a little issue getting what I want displayed from a single table. Basically, here is what I am trying to accomplish. I have the following type of table: Place Action B/S Qty Type City Full B 1 View City Partial B 1 View City Partial B 1 … |
| | Hello, I'm having problem with a query which is based on fixed-part and all I do is that I'm modifying part after WHERE something.value='... . This whole text is a string which I need to be connected to my query. '113') AND (reklamace.kod_reklamace = '932' ' Error message: Conversion failed … Databases mssql |
| | Hi, I am creating an inventory control database, and my products are using serial numbers, I am stock in desinging the tables needed . Produts in stock 50 I need to store 50 serial numbers for that product. One product number has many serial numbers. Products can be in many … Databases web-design |
| | Hi people, My issue is more of a MySQL issue than php. I am trying to store a 3digit integer value with a leading Zeros in front such as 001 i have a company table , which auto increments the id as 001, 002, 003...and so on... In the company … Databases mysql |
 | Hi guys , I am creating a timekeeping application to keep track of users. In my database I have a table which stores the time a user starts their break and finishes their break. I want to return the total time that the user is on break in minutes to … |
| | Hi peeps... A good day to all of you yea~ as i know, i can retrieve only the first row by using the keyword [B]limit 1[/B]: [CODE]select * from tblTesting limit 1[/CODE] for selecting the first two rows are: [CODE]select * from tblTesting [B]limit 2[/B][/CODE] is there any solution to … Databases mysql |
| | I am New TO Programming Am HAving 2 Table One Table Having Coloum ID and NAmeOf Eventt And Other Table Having Coloumn ID and Imagepath I want To Retrive Id related the NAme Of Event and Want To Insert That ID into other Table at the same time i want … Databases mssql |
| | Hi to all, We use normalization to control the redundancy.. What is the purpose of using Denormalization in sql ? Thank you, Prem Databases  |
 | Hi guys, Basically I'm making an auction website (kinda like eBay), and am trying to make my database 2NF compliant (and eventually 3NF compliant). Here is an outline of my tables/fields: [ATTACH]14300[/ATTACH] I know I need to split the tables up into additional tables so that data isn't repeated, but … Databases |
| | Hello! I'm hoping that you can help me Alter a SQL table to provide a unique constraint over 2 columns. For instance let's say I have a departments table called Dpt_tbl with two columns that I want to be unique Name Location So I want to make sure that you … |
| | Hi, i've been working on this simple homework assignment and the only thing stopping me from finishing it is passing a c++ variable to a mysql query using mysql_query. I've searched around for about an hour and every potential solution I have found hasn't worked, so I figured maybe if … |
| | Hi, I’m going to calculate a ratio between two entities but are having some trouble with the query. The principal is the same to, say a forum, where you say: A user gets points for every new thread. Then, calculate the ratio of points for the number of threads. Example: … |
| | I have a table with about 150,000 rows. The table never changes and the rows are physically ordered by one of the columns. That column is the only column I ever need to query against. The values (TEXT) in that column are not distinct. Creating an index on this column … Databases mysql |
| | Hello I need help to turn this Scenario normalized from 0nf-3nf Please thank you… [B][U]Scenario[/U][/B] Company details Swapsongs plc organises Record Fairs throughout the UK. They book and pay for venues eg hotel or leisure centre, each venue has a name, address, phone, contact name, cost per day, max – … Databases user-interface |
 | Hullo, I would like some one to help me connect my access database to my website. The Database Name is school.mdb and the website is <URL SNIPPED>. Thanks Databases microsoft-access |
| | Hi, Not sure if this is right place to post this, please move if needed. I set up a web form so that the text from a set of text boxes was inserted into a database when you 'submitted' the form Since then I have added some validation to the … Databases mssql open-source |
| | hi, i have been trying to write a query which will return all clients and the related tables so that i can then allow the users to filter in a php website. at moment i tried this but returned no results even though there are records: [CODE]SELECT * FROM clients … Databases mysql  |
| | I running MySQL 5.1.30 on Solaris 10. As I have a table which I partition into 12 according to each month. The table structure as follow [CODE] mysql> desc my_events; +-----------+--------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-----------+--------------+------+-----+---------+----------------+ | event_id | bigint(20) | … |
| | Hello I need to set up a database for a company that has 40 employees. The employer wants the employees to log in to the web site and view their work schedule. A non technical person would need to create and submit the schedules weekly. What type of database do … Databases |
| | Hello, can you help me convert MS SQL DateTime to miliseconds since 1970? Thanks, Domen |
| | DOH spelt thread name wrong... should be query! This is surely simple... this is the end of my query [CODE]where CCM0300.dbo.Device.tkModel= '72' AND CCM0300.dbo.NumPlan.DNOrPattern like '31455' OR CCM0300.dbo.NumPlan.DNOrPattern like '38600' OR CCM0300.dbo.NumPlan.DNOrPattern like '36305' OR CCM0300.dbo.NumPlan.DNOrPattern like '36805' OR CCM0300.dbo.NumPlan.DNOrPattern like '38285'[/CODE] what this is meant to do is return … |
| | Hi I need to create an SQL to retrieve the max date for each change in stock code. can anyone assist please? I am extremely new to SQl. I used access to get external data but it drags down 60,000 odd lines. i only have 5000 line items so with … Databases mssql |
| | Dear all, I am very new at SQL programming and are using the Microsoft Query to avoid alot of SQL programming, but I am stuck on one thing when I try to filter some data from the database... I want to show all delayed deliveries to our customers... Our Policy … |
| | hi i have a query and i want to use it in remote server when i try to run it in my machine it executes ok. but in remote server it cannot be executed. im connected to the remote server and i can view all the records in the table. … |
 | Just struggling through my SQL coursework, and already fallen over the first stubling block :( My case study tells me that i need to put a foreign key from my centre table (parent) to my salesman table (child) on a 1-1 relationship. Trying to add my foreign key, which is … |
| | Hi everyone, I'm currently working on a assignment and have to write a short (max 3 lines) definition on some different kinds of queries. I've written a definition to all of them but I'm having a really hard time about one particular query: Scan Query. I've tried to look in … |
| | I have one join query with 3 tables, which takes lot's of time to execute. I need to reduce execution time i.e., optimize it [code] QUERY: SELECT SQL_CALC_FOUND_ROWS p.*, FLOOR(p.prodratingtotal/p.prodnumratings) AS prodavgrating, 0 AS prodgroupdiscount, pi.* , (IF(p.prodname='gold', 10000, 0) + IF(p.prodcode='gold', 10000, 0) + ((MATCH (ps.prodname) AGAINST ('gold')) * … Databases mysql  |
| | Hi everyone, I’m having some difficulties with a query which purpose is to give users with more than one thread (called CS) in current year a 5% point “raise”. My relational schema looks like this: Thread = ([B]threadid[/B], threadname, threadLocation) threadoffering = (threadid, season, year, user) user = ([B]name[/B], points) … |
| | When some datas are inserted in to a DB table from a jsp page, how do i get the primary key in my table autogenerated?? finiding out the highest value for the primary key in the table? Pls help me wid the coding in JAVA or HTML.. I use SQL*PLus. |
| | Hi all, I've looked through this forum for some hours and am absolutely unable to fix my problem; no matter what I do. I'm trying to pass a PHP variable as part of a MYSQL query like so: [CODE] $id = $_GET["bodyid"]; $blog = getEntries("SELECT `Articlebody` FROM `Blog` WHERE id … |
| | This has taken many hours of mine. I have to get this .Net app to run on an XP system. Someone seems to have messed up some files so conn.Open() in the C# is causing this error: [CODE]Connection Error:Oracle.DataAccess.Client.OracleException ORA-12170: TNS:Connect timeout occurred at Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, … Databases asp.net client-server oracle |
| | Hello I have 2 databases, one is like a backup for the other. So they have identical tables: Alarmi, which has columns: OBJEKT, OPIS, VREDNOST, START, E_A, UPORABNIK I want to compare those two tables and copy only new entries (rows) to the backup database. How can I do that? … Databases mssql |
| | Hello all, I am trying to create a database using Microsoft Access based on the folowing scenario. However, before doing this, I am trying to figure out the logic and draw an ERD. The scenario is as follows: "The Meantime agency manages properties for rent in South East London. Clients … Databases database-design microsoft-access |
| | Basically I'm a noob with database work andjust need a kick start to complete the rest of my other diagrams, seeing as the use case was the first step I thought I would ask for some help :D So this is my situation, can someone help me make a use … Databases |
| | hi, could anyone recommend a free mysql query builder? i have been working on a database and had some help with some small queries, however i need to create a large recordset through dreamweaver and wondered what tool i could use to generate my query visually? many thanks Databases mysql |
| | Hi everybody. right now i'm doing a hotel reservation system using php and phpmyadmin. The process involved 1) user inputs check-in and check-out dates (to check what rooms are available during the dates input) 2) database is queried for all room categories AVAILABLE within the dates indicated step 1 and … Databases data-structure mysql |
The End.