128 Posted Topics
 | You really need to have a long look through Books On Line for this one. MS SQL Server authentication works, as you know, in two ways. Windows authentication or Mixed mode (Windows authentication and SQL authentication.) SQL authentication requires a username and password, registered in the SQL Server, to be … |
| | SQL Server needs a small number of parameters passed to it on start up. Things like where the MASTER database is, error log location etc, have a look in Books On Line. It is also notoriously memory & CPU hungry. Fill your server up with memory and use the fastest … |
| | In Enterprise Manager highlight the database name, right click and chose VIEW > TASKPAD. This will show if there is any free space and where it is. You might want to make notes of the amount of free space and file sizes too. You can then chose to right click … |
| | A thought first of all, your example data doesn't match your example results. So actually no one could produce the correct results from this data. However, build and test each separate row of the required result set separately. Then join then with a UNION clause. |
 | Look at [URL]http://en.wikipedia.org/wiki/Database_normalization[/URL] |
| | This is very simple to do. Books On Line CREATE TABLE or ALTER TABLE will give you all of the information you need together with examples. |
| | It sounds as though you may have screwed your HTML service (Apache or whatever.) Check the configuration file where you made the change to introduce GD and comment out the change. Restart the service and check is the PHP files are being pre-processed. If everything is back to normal then … |
| | You do know lines 15, 24 and 33 are missing closing double quotes don't you. This will certainly cause the problem you're complaining of. |
| | Ummm, bit of a discussion area this one. You don't _have_ to have an index on the column you test against. But it will improve performance if you do. As for the storage overhead, disk is cheap, but people get very annoyed when their queries are slow, and they tend … |
| | |
| | Re: Max Date Help samaru; Your code will only return one row. The correct code is - [code] SELECT DISTINCT t.stock_code, t.stk_trans_type, t.stk_trans_whse, t.tk_trans_date from [YOUR TABLE NAME] t WHERE t.tk_trans_date = (SELECT MAX(tk_trans_date) FROM [YOUR TABLE NAME] s WHERE s.stock_code = t.stock_code AND s.stk_trans_type = t.stk_trans_type AND s.stk_trans_whse = t.stk_trans_whse) [/CODE] |
| | One way you might do this would be to identify the day (of the week) number of the start date. i.e. Sun = 1; Mon = 2 etc. For valid starting dates (Mon to Fri) you have a range of 2 to 6. Now It is easy to see that … |
| | I found typing SCAN QUERY into Wikipedia's search box brought back a number of interesting results. As you seem to be a student, prehaps a little investigation might be in order. |
| | Not sure about this one. Looks like a stored procedure may be required. Or possibly views based on views. The major problem as I see it is that once you've tested row 1 against all of the others you now have to do the process again starting at row 2, … |
 | Well how about SELECT A.* FROM OWNERS_ANIMALS OA, ANIMAL A WHERE A.ANIMAL_ID = OA.ANIMAL_ID AND OA.OWNER_ID IS NULL Should work  |
| | Please be aware that web hosting aimed at the 'personal' market will have low quotas applied to the bandwidth and size. I _personally_ have found a small business account to be best _for me_. I use [URL]www.1and1.co.uk[/URL] and I understand that they have a '.COM' site too. What ever you … |
| | Ardav, You've got a lot more patience than me. I'd have chucked this threat ages ago. Midnite, The posters on here have been trying to help you learn. And learning isn't easy it takes _your_ effort. Through out this post you've asked for a script so you can test it …  |
| | Many different ways to solve this one. ASSUMPTIONS 1) There are two tables, FILES and RECORDINGS 2) FILES has a column called ID and a column called IS_IN_RECORDING 3) RECORDING has a foreign key column pointing to FILES.ID. 4) RECORDING has one (or more) boolean columns defining the status of … |
 | This really depends on what you mean by archive. Do you mean copy a row / some rows from one table to another, one DB to another? How are the rows selected? So many questions, I'm not really surprised no one's answered yet. |
| | |
| | And the error messages even showed the line numbers where the errors are.  |
| | Oh, I thought you started this threat because everyone on the old thread wanted you to do some work and show your code so they could help you improve it. But all you were asking for was completed code. It might also help if you explained [B]why[/B] you wanted help …  |
| | Just a few thoughts which may be of help. People {Users} eat food. This food might be a recipe or a primary food (i.e. an egg). They also eat quantities of both food and recipes. So you will need a many to many relationship between the users and the recipes … |
| | If you are using MYSQL then LIMIT <offset>, <rowcount> is your friend. If your page can accept a page number via GET or POST, not forgetting that the initial call to the page is unlikely to have this parameter, then you can use that page number to alter the <offset> … |
| | Initially it looks as though you've answered your own question. The table and records shown build a binary tree which can be walked down or up. So what isn't this doing that you want it to? |
| | This might help. [url]http://uk3.php.net/manual/en/book.xml.php[/url] |
| | It looks as though you haven't really considered all of the information you are interested in. You have seemingly vague suggestions of requirements, but you are missing so much more. What data needs to be on the invoice, how often are the clubs invoiced, how much information do you keep … |
| | |
| | It would probably be better, especially for audit trails etc, to leave the current IDENTITY column intact and add another column to show if the row is active or deleted. Then your users can make their current allocation of errors and just tag the record as deleted. The VAT / … |
| | Odd one this. Answered a question similar to this a while back but that was specifically about being a DBA. And remember my experience is in the UK. :-) Firstly if you don't have a degree then you will be fighting a hoard of degree possessing opponents for any job … |
 | Re: Dani's Cookbook Well, to help a malnourished ex-colonial :cheesy: heres my input. 1K chicken livers 1 standard tin chopped tomatoes 2 mid to large onions 2 tablespoons tomatoe puree 8 oz rice Olive oil Garlic cloves or minced serves 4. put 1 1/2 pints of water into a 2 pint pot, put … |
| | What happens if the user doesn't fill in all of the options? Are there defaults for every possible CSS value? Is the input validated for the difference between "#FFFFFF" and "WHITE"? Both of these are valid CSS color options. **I DO NOT KNOW HOW YOU OBTAIN YOUR USER INPUT** But …  |
| | Need more information to be able to answer this one. Which DBMS are you using? |
| | You would be better off asking this question in your favourite search engine. |
| | Re: TSQL problem Try INSERT INTO person (name, surname, fk_accessid) values ('$name', '$surname', (SELECT DISTINCT id FROM access WHERE name = '$uid' AND psw = '$psw')) Although I would prefer something like - $msquery = "INSERT INTO person (name, surname, fk_accessid) values ('" . $name . "', '" . $surname'" . ", SELECT … |
 | |
| | Have a look through this [URL="http://www.geekgirls.com/databases_from_scratch_1.htm"]http://www.geekgirls.com/databases_from_scratch_1.htm[/URL] Very good intro to DB design. |
| | RamyMahrous' solution doesn't work. Use this instead. select min(s.column) from (SELECT TOP 3 (column) FROM table ORDER BY column desc) s |
| | Your hair's a mess and your shoes don't go with your trousers. And when DID you think that that tie went with that shirt! :) |
| | Simple pragmatic rule. 1) He's the boss. 2) If he's wrong refer to rule 1. |
| | Ramy, What you have described is CLIENT / SERVER architecture. Distributed Database Program Development "sounds" like something else. Sarah, Please could you expand your definition of Distributed Database Program Development. Thanks, PCLFW |
 | Ramy, Without being facecious - 1) Remember you NEVER STOP LEARNING! 2) Buy Books on the subject and on the tools you are using. READ them all from cover to cover. Make notes in the margins and use POST-IT notes to mark sections of special interest. 3) Find a more … |
| | [QUOTE=jwaldron82;787780] Un-Normal Form (UNF) Owner ( OwnerID, OwnerName, OwnerContact, ArtID, ArtTitle, ArtistName , Exhibtion, ExhibitionTheme) [/QUOTE] 1) First normal form removes repeating items. [url]http://en.wikipedia.org/wiki/First_normal_form[/url] Here the repeating items can be OwnerContact (an owner may have a number of different contact details), ArtID (one owner may have may items in an … |
| | I have a number of points here. 1) If each row in the EMPLOYEE_WORK table has a ROWID IDENTITY column (or similar) then you don't need the date column. INT columns are smaller that DATETIMES as well. 2) Using your defined EMPLOYEE_WORK table is fine for two or three employees … |
| | [QUOTE]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 end date … |
| | I am making an assumption or two here, such as LOGID, your primary key, is an IDENTITY column or similar, so try this [CODE=SQL] SELECT e.logid, e.eventid, e.description, e.logtime, l.logid, l.eventid, l.description, l.logtime FROM logtable e, logtable l WHERE e.eventid = <event id that you want to examine> and l.logid … |
| | Re: "Common" tables I have used this style of table reuse before and always handled the releationships in the application. As you say if you try to set foreign key relationships from either the COMPANY or CONTACT table you will always get a key constraint violation when entering a record into either of … |
| | You have two options, both explained in books on line. 1) UPGRADE the server. This will upgrade your server from 2000 to 2005. It is a one way move and the whole server is changed. There is no rollback for this. 2) MIGRATE the database. This is a lot more … |
| | This type of question can most easily be answered by normalising the data. Correct nomalisation will show which of these entities 'owns' the others. For instance Can a CASE have more than one CLIENT? I expect that a CASE may have more than one INVOICE, but does an INVOICE get … |
| | PHP will allow you to format the display of data in any format that you can think of. Remember that you are taking data out of an array and placing it into holders, usually columnar but they can be a horizontal series [d1 d2, d3 d4 d5 d6 d7 d8 … |
The End.