Databases Forum

Hi guys, I'm brand new to SQL and was looking for any help I can get my hands on! What resources does everyone find useful?? Books, magazines, links, forums, etc.??? My friend shared this one with me so I thought I'd pass it along, I've found it pretty informative and …

hey all i need to find the birds with the largest number of habitats. attached is the database i am working with. i sort of need the solution in about 2hrs time.... thanx ali

[COLOR=#000000]I have two record sets. One is transactions and another is GL posting. I am aiming to create a third table to find out the customers are from which country inflate our GL.[/COLOR] [COLOR=#000000]For example GL Table has following fields[/COLOR] [COLOR=#000000]GLCode[/COLOR] [COLOR=#000000]GLDescription[/COLOR] [COLOR=#000000]GLAccount[/COLOR] [COLOR=#000000]GLAccountCCY[/COLOR] [COLOR=#000000]Balance[/COLOR] [COLOR=#000000]BalanceUSD[/COLOR] [COLOR=#000000]Transaction Table has the …

Hi, I am writing a query that requires as input the difference in days from two dates (Project_End - Project_Start, both of data type DATETIME), how can I find it? Can I subtract the two dates? Thanks, Robert

Hi, I'm a bit stuck. I've been breaking my head quite long figuring how to do this. I need to generate areport that is grouped by week. i need to display total number of patients who are enrolled in the system. And they are grouped by the weeks in a …

Hi there, I'm trying to screen some programmers I'm looking to potentially hire & I have a list of questions a previous programming consultant drew up, but I don't know what to do with them b/c he did the screening b4. Can someone please help me determine if I place …

Hi , I've been working on comparison query with PHP and MySql 5.0 yet not getting anywhere with it. I'm trying to perform a search ( query ) I have several tables within the same database that contain same fields yet hold different data eg Table 1 id |Product | …

Hello, I have two databases on my website lebphoto.com with the same tables. One with a 1665 members and the other with 33 members, I want to merge them together. is there a way other than typing each records by myself or ask the members to register again? Thank you

Hi, I have to design a Database as part of my assignment. I'm currently half way through and I'm stuck on the follwing in one part of the written assignment. Please can you help? Thanks. You should review the [B]development methodology[/B] which you used and its effectiveness. Two alternative methodologies …

Hi everyone, What is the difference between UNIQUE and DISTINCT? It seems that they do the same thing. Thanks, Nick

Hi, I have a small database with 15 tables and 20-40 records in each table. I just want to ask how can I print all the tables together with their names, atribute names and all the records? (the Print option from the File menu is not active) Thanks, Robert

Hi. I have just installed 2005 in my on my database server. Now, I have a web server and will need to access my database from my web server for simple stuff such as querying the database and checking tables, etc, etc. What should I be installing on the Web …

I have a view that looks at new student records and a table that stores those records and information related to their Active Directory logins. What I need to do is filter out any duplicate records between the two "tables". So I only see unique records in the view to …

hai, i m new to this site and my 1st post is this. I have a table which consist of some tuples. i didnt set any primary key. by mistakely i entered the same values for two tuples. i want to delete a single tuple without copying the table to …

HI, [COLOR=#000000]I am trying to return automatic value into another column with using trigger in a table, when I enter new record into that table. It works if it is first data to be in that table. If I have more than one record already, it doesn’t work. I thing …

PopUp Windows I just started with Oracle 10 XE (Express Edition) and found a kool How To on creating PopUp Windows in Application Express [URL]http://www.oracle.com/technology/products/database/application_express/howtos/how_to_create_custom_popups.html[/URL][URL="http://www.oracle.com/technology/products/database/application_express/howtos/how_to_create_custom_popups.html"] [/URL]

I'm making a forum-like program, and I'm having difficulty designing a particular feature. I want it to store if a user has viewed a particular post or not. I'm not sure exactly how to go about this. What do you think would be the best approach? Thanks, Andrew Arnott

I have created the following stored procedure in sql server 2005.I m using asp.net with C# 2005. Can someone please rectify my errors why i m getting such type of the errors... [code] ALTER PROCEDURE CompanyStoredProcedure @uspcompanyid INT NULL, @uspcompanyname VARCHAR(20), @uspaddress1 VARCHAR(30), @frmErrorMessage AS VARCHAR(256) OUTPUT, @RETURNVALUE AS INT …

Hi, SELECT * FROM veriler WHERE (name LIKE '%in%') This line doesn't work in Ms Access, IN either. No error is given is well. But It works in SQL server. How can i do in Access? Thanks

Well, whenever I try to run a user verify script, that asks SQL if a username is not taken, I always get this response... [quote][B]Warning[/B]: mysql_num_rows(): supplied argument is not a valid MySQL result resource in [B]dir/userver.inc[/B] on line [B]11[/B] count unavailable[/quote] this is the code in general: [php]<?php //User …

Hi, i'm new to all this. I'm really stuck!! I'm running XP Prof and have recently installed SQL Server 2000 Personal edition. It seems to have loaded in ok,,BUT,,it won't connect to my localhost,,i don't know what the problem is i get the 1069 error message. Pleaaaaasssee can someone help …

Hello I have successfully exported a recordset to an Excel template and saved the template as an xls file. However, when I open the Excel file all the worksheets are hidden. Does anyone know why and how to stop this from happening. thx Wayne

Hello everyone, I have an Access question. I have two date fields (field 1 & field 2), and both are formatted for "General Date". Since they are used in a calculation of Date and time, I need both segments to be entered. What expression can I input into the "Validation …

can any body tell how to delete all the tables in a user ata a time

Having a diificult time with date range in a pawn database: Any suggestions

Hi there, I am relatively new to MYSQL and i have to design a database for stock for a dvd firm, this database has to link up to a website, the website is a DVD firm so the only things that needs to recorded in the database is how much …

is there any way through which we can generate reports in mysql. not using any s/w but coding. if yes plz tell me Thanks

I need to be able to have users click on a form field that is an email address to contact the "contact" - it is proving more complicated than I thought. ANY Suggestions will be welcome.:eek:

Hi every1, Is there any way that i can secure my ms access. i want when ever any one opens my database,it should ask for a password. any way of doing it? the database has already been created thanks in advance

hi all i m making a project using jsp as my front end and mysql as my back end. i had to change backend from oracle to mysql bcoz of clients request. now there is 1 problem i m facing. there a password change option. person enters its old password …

I have a field on a form which is calculated (A minus B). It displays properly on the form with the correct answer. I can't figure out how to get it to pull into a query? My query is pulling any record with that field criteria >0 and no records …

Is there a way to store multiple enteries in a same field (Like adding delim's..etc , which would be considered while we are firing queries at them) Ex: i have a field named subjects.. is is supposed to have multiple entries in the same field (English , maths ,etc) Is …

Hi, Sorry for posting in Web Dev even though this is an App Dev question. We're looking at methods to create a new application. The application will be used heavily by about 20 people concurrently, it needs to be very user friendly and highly interactive. IT have nominated Java/Python/.Net or …

I hav calculated a value(years).Now i want 2 merge it with an attribute of a table.So i want 2 merge ml_y and 2.then i want to find the value of ml_y2 frm a table....plzzzzzzzz help me .can i do somthing like this in MY SQL???

[B]When i try to access this page: it shows this: Warning: mysql_query(): 2 is not a valid MySQL-Link resource in /user/langlab/wwwhome/signup/signup_adm.html on line 28 Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /user/langlab/wwwhome/signup/signup_adm.html on line 29 Warning: mysql_query(): 2 is not a valid MySQL-Link resource in …

Forgive my ignorance, I am new to RDMS and SQL both. My question is this: I have 2 tables, one a primary table and 1 a relational table table 1 has ten rows valued 1,2,3,4,5,6,7,8,9,10 table 2 has 4 rows keying from table 1 row1 = 1 2 row2 = …

hi every1 i m using jbuilder9 to develop my website and mysql as its back end when i use mysql with simple java program it runs as i store the jconnector in jdk1.3/lib/ext. but when i stor the jconnector in jbuilder/jdk1.3/lib/ext it does not work. can any 1 plz tell …

hi every1 i hv created my database in mysql now i have to run the s/w on my clients system. can any 1 plz tell me the steps to export the mysql database and then to import it on my clients computer. thanks in adv

Hi I am very new to MySql. I want to use Navicat along with MySql server to develop and maintain very simle database in future. Up to this point it is OK. I want to develop and maintain a small customer database. My question is do I need a GUI …

Hi, I am trying to understand MySQL as i am new to this and i have a few queries I am having problems with and I was wondering if anyone can help me with it.. How would you solve this problem using the Select, from, where etc commands. For example …

Hi, I forgot my Ms. Access Database password. :eek: Is there a way that I can recover it..? For your information, I split the database into two files, the front end and the back end. Now, I can't open the back end, although the front end still works. Help.... :confused:

hello please I want program of Relational Rose (trial version) so.. can u help me?? best regards :)

I have a db full of articles that have a category field. Is there anyway to select and display just the different categories?

How can a band create a mialing list to send out show responses thanks rob

Hi im new to this but i am doing a project for my business, i was wondering how in the validation rule you can set it so that it will have an error message if i do not insert a decimal point e.g for car enngine size 1.6 if enetered …

SELECT * FROM `studentcourse` WHERE `systemcode` = 'ilscorp' AND `status` = 'complete' AND `techcode` IN (SELECT `techcode` FROM `usersubscription` WHERE `subscription_id` = '296') After I run this the server has an intense lag and needs to be restarted or timeoutes occur.

Hello, I am going to study MySQL on my web server. I would like to ask if there is a useful GUI tool for MySQL to create/delete tables and browse entries on my database.

Hello, I heard SELECT COUNT(*) can take a lot of resources if your counting a table with lots and lots of rows (hundred thousands, millions). What if you add A WHERE clause to it? So something like: SELECT COUNT(*) FROM table WHERE pid = ? (pid is a index too …

I have a school problem, I'm not going to try and hide it. This is for Oracle9i: SQL class. The question we have to write a code for is: Create a list of customers that will display the characters 'NOT REFERRED' if the customer was not referred by another customer. …

Hi, I am trying to install oracle 10g ODBC driver in my comp. When I downloaded the oracle10.2.0 version into my comp n unzipped tht exe file.According to readme.txt file in that i should run "product.jar" file in the filelocation .but i could not get that.it consists of only products.xml …