DaniWeb IT Discussion Community - 16,126,127,128,129,142

Retrun a result of zero if no query results

mela1006 — Tue, 08 Dec 2009 21:39:31 GMT

I have the following query in MS Access 2007

SELECT Projects.BIMinspector, Sum(Projects.R9) AS SumOfR9

FROM Projects

GROUP BY Projects.BIMinspector

HAVING (((Projects.BIMinspector)=[forms]![Form Report]![Elist]));

How do I get it to return a result of zero if no records are found??

Any suggestions would be great.

Thanks,

help with sql join

alohaaaron — Tue, 08 Dec 2009 21:02:55 GMT

Hi, I have the query below with the data and query below. I want to select dates from Intable that are with a one month range of the Outtable dates and group them. That works fine

But I also want to select values within these data ranges where valuein=valueout.

The end result should read.
dateout total mymatch
2009-01-05 5 2
2009-03-01 4 3
2009-04-01 4 3

instead of.
dateout total mymatch
2009-01-05 5 3
2009-03-01 4 3
2009-04-01 4 3

================================

SELECT o.dateout, o.valueout AS total, count(i.datein) AS mymatch

FROM (SELECT dateout, count(*) valueout FROM outtable GROUP BY dateout) o

LEFT JOIN intable i ON i.datein BETWEEN o.dateout and ADDDATE(o.dateout, INTERVAL 1 MONTH)

GROUP BY o.dateout, o.valueout

================================
Outtable
dateout valueout
2009-01-05 05
2009-01-05 06
2009-01-05 07
2009-01-05 50
2009-01-05 51
2009-03-01 05
2009-03-01 06
2009-03-01 07
2009-03-01 18
2009-04-01 05
2009-04-01 06
2009-04-01 07
2009-04-01 21

Intable
datein valuein
2009-01-05 12
2009-01-06 06
2009-01-08 07
2009-03-03 06
2009-03-04 07
2009-03-05 05
2009-04-02 05
2009-04-15 06
2009-04-16 07

Getting time out error while retrieving large data from MySQL.

Vandithar — Tue, 08 Dec 2009 08:29:02 GMT

Hi,

I am using MySQL Version 5.0.45. I am getting time out error while trying to access large data.

I am performing 2 operations:

a) I am loading the data file into the database
b) I am retrieving the data from the database.

1) Loading the data file into the database.

I have 9000 entries in my file. I am using by tab separated delimiter to delimit the field and loading into the database by the following command.

LOAD DATA LOCAL INFILE '/home/group1/cgi-bin/pubmed_abstract/writecatg.txt' INTO TABLE limits_title FIELDS TERMINATED BY '|' (sentences, searchterm, ids)

#Here is the sample data:

Perl is a highly capable, feature-rich programming language with over 22 years of development.| PERL | 32

2) Retrieving the data.

In order to retrieve the data i am using "select" query and free full text searching for the user given query term (User will give search term say "Perl" the records that has term Perl will be retrieved).

I am retrieving data like this:

select * from limits_title where title RLIKE'[[:<:]]perl[[:>:]]';

Most of the times user will give Boolean combination (For Example: PERL OR phython)

The problem now is some times the result will not be displayed or it gives timed out error.

How can i solve this problem?

Is there any method available such that i can fasten the retrieval and loading process?

I am using PERL DBI to connect to MySQL.

Any suggestions?

Regards
Vanditha

(rsErrorOpeningConnection) Could not obtain information about Windows NT.

ChelleATL — Tue, 08 Dec 2009 05:58:30 GMT

I am trying to deploy a report to the Reporting Services Server but keep running up against this error:

Quote:

An error occurred during client rendering.
An error has occurred during report processing. (rsProcessingAborted)
Cannot create a connection to data source 'dataSource1'. (rsErrorOpeningConnection)
Could not obtain information about Windows NT group/user 'DOMAIN\useradmin', error code 0x5.

Here’s my situation: Everything is being ran using DOMAIN\useradmin and the report is using a remote database.

Reporting Services and SQL Server are both ran under DOMAIN\useradmin. DOMAIN\useradmin is a windows AD login and is part of the server machine Administrators group.

My test report is using a data source model that in turn is using a data source that is connection to a database on a different SQL Server. The data source is using “Credentials stored securely in the report server” with the options “Use as Windows credentials when connecting to the data source” and “Impersonate the authenticated user after a connection has been made to the data source.”

I am using the credentials of DOMAIN\useradmin that is the db owner of the remote database.

DOMAIN\useradmin is assigned the roles, System Administrator, System User and Browser, Content Manager, My Reports, Publisher, Report Builder.

So if everything is being run under an über AD account, why I am getting this Could not obtain information about Windows NT group/user 'DOMAIN\useradmin' error?

Under normal circumstances , an AD login with Publisher permissions will developing reports using a datasource model created by DOMAIN\useradmin but using one of the remote database’s users which is mapped from yet another AD login.

How to create a flat file in Oracle

wolverine_ramir — Tue, 08 Dec 2009 02:46:16 GMT

I would like to know how do i create a flat file from a query in oracle. For example i would like to create a select statement and the output to the flat file should be like this:

name,location,address
......

Later on, this task will be embedded in a unix script (the call for the procedure if created in a procedure) and i would like to know how would i achieve that. The flat file will be stored in a unix directory. I used spooling but it is printing even the sql statements i have executed in sqlplus so i don't want to use that. I have searched on utl_file package, but this requires to be installed in the oracle and with that, i need to communicate to a DBA to add the package and it takes time or it will be laborious when it comes to requesting. What are other ways?

Any help would be of much service.

ERD for tuition school

billdara — Mon, 07 Dec 2009 15:48:22 GMT

Hi All

I'm new to this forum and i would be really greatful if I could get some help!

Someone I know has his own tuition school and I must develop a website for him and I dont know lot about anythng to be honest. Not a great programmer or not very good with databases. It is more of a college project.

I'm developing it with PHP and xhtml, css etc.. and using MySql as the database.

At the moment I am trying to design an Entity Relationship Diagram and im seriously struggling. I will give a description of the functionality of the site and any help would be appreciated.

Functionality:

The site will have four separate sections. A students section, teachers section, parents section and administrator section.

Students can first sign up to the College to get their MyCollege privileges. When joining up the student will have to enter such information as name, address, date of birth, year at school, contact details etc…
Once the student has an account on the College site he/she can log in to their own unique section of the site where they can view/edit/delete their personal details.
They will then be able to enroll in a number of services, including various courses (English, Maths, Science etc...) which will show in dept information about the actual course including teacher, course outline, times etc…

If a student attempts to enroll in a course which is full, or the time is clashing with another couyrse the student is enrolled in, the system will not allow the student to sign up to the chosen course, instead an email will be sent to the administrator of the site informing him that a new student wishes to sign up for a course. Because this student will already be a member of the system and all of his/her details will be in the database, it will be easy for the admin to contact the student and discuss other options.
If the course is available then the student will have the option to pay upon arrival to their first class or pay online via PayPal.

The student will then be added to the chosen course. Supervised study is another service available to the student. This will work in a similar fashion to the course enrolment, except instead of different subjects there will be different packages or time slots. E.g there is an evening study time slot and also a Saturday study time slot. When the student is enrolled in the supervised study service he/she will be able to view timetables and seating arrangements unique to them.

The teacher sign up will be similar to that of the student except some of the personal details will be different. The teacher can log in to their own unique MyCollege which will have different functionality than the student’s section. If for example the teacher is tutoring in more than one course, he/she will be able to click on the course of choice, for example English, then the teacher will be able to see all of the students enrolled in that course.

They will then be able to click into each of the individual students to see some of their information (non personal). The teacher will be able to grade students, leave comments and make recommendations about students which the administrator can later take on board, do out reports to give feedback to the parents and students themselves.

The teacher will be able to upload lecture material from previous classes to that only the students enrolled in his/her course can view. The teacher will also be able to interactively take attendance on the system which will all be logged and attendance reports can then be generated on this information. A function where if the student is missing a class, an automatic email/SMS is sent out to the parent of the student is also needed.

There will be a parents section where by the parent of a student attending the college can log in and observe how their son/daughter is doing; how their attendance is, how their academic performance is doing and if their keeping up with the material, and also to see if their teacher has any comments.

The administrators section will be able to look at all aspects of the system. From approving students when they sign up, to checking attendance, checking academic performance of the students, making sure lecture material is being uploaded, adding/editing and removing members and teachers, reporting. Basically the admin will control every aspect of the system.

Any help at all would be much appreciated.

Thanks a Million
Billy

How can I connect my database on my localhost site driven by cakephp

leahmarie — Mon, 07 Dec 2009 07:57:27 GMT

Hi guys, I'm not sure if this is the right category for this inquiry. I have my phpmyadmin working for my existing database but I couldn't make it to work. The site is running in xammp localhost. I have the data in place . I get the database to run but I couldn't connect it to my site so my layout won't appear. need help badly.

Getting Field name from a select statement

awo — Sun, 06 Dec 2009 09:28:40 GMT

Is it possible to get the columns name from a select statement involving more than two table.
eg

SELECT a.field1, a.field2,b.field3,c.field4 

FROM a,b,c 

WHERE a.field1 = b.field1 and a.field1 = c.field1

is there a mysql statement that returns a record set containing field1, field2, field3, field4 that can be sent to an array that can be used in a php script.

mysql_num_rows(): supplied argument is not a valid MySQL result resource Problem

Gibson_Junk — Sun, 06 Dec 2009 04:19:51 GMT

Hi i just did some codoing and heres the error i get when i try to use my register forum

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/rpimager/public_html/RPImager/register.php on line 32

Account created.

Here's the docs that i use it for. why i getting this error

config.php


//Configuration File





//Usually localhost

$host = "localhost";



//Database Username

$username = "";



//Database Password

$dbpass = "";



//Database Name

$dbname = "rpimager_test";







//----Do not edit below this line unless you know what you are doing.----

//Connect to DB.

$db=@mysql_connect ("$host", "$username", "$dbpass") or die ("SQL Error
Please check your database connection settings.");

mysql_select_db ("$dbname");



function user_login ($username, $password)



{



//take the username and prevent SQL injections



$username = mysql_real_escape_string($username);



//begin the query



$sql = mysql_query("SELECT * FROM usersystem WHERE username = 'username' AND password = 'password' LIMIT 1");



//check to see how many rows were returned



$rows = mysql_num_rows($sql);



if ($rows<=0 )



{



echo "Incorrect username/password";



}



else



{



//have them logged in



$_SESSION['sername'] = $username;



}

}

//Get data from SQL DB.

$sql=mysql_query("SELECT `Value` FROM `general` WHERE `Name`='Title'") or die (mysql_error());

while($row=mysql_fetch_array($sql)) $title = "$row[Value]";



$sql=mysql_query("SELECT `Value` FROM `general` WHERE `Name`='Ad_Code'") or die (mysql_error());

while($row=mysql_fetch_array($sql)) $adcode = "$row[Value]";



$sql=mysql_query("SELECT `Value` FROM `general` WHERE `Name`='Ad_Code_Downloads'") or die (mysql_error());

while($row=mysql_fetch_array($sql)) $adcode1 = "$row[Value]";



//Steralize a few vars.

$search = stripslashes(strip_tags($_GET[search]));

$filetype = stripslashes(strip_tags($_GET[ext]));

$source = str_replace("|", "", stripslashes(strip_tags($_GET[source])));

if ($source == NULL) $source ="all";

$page = stripslashes(strip_tags($_GET[page]));

if (!is_numeric($page)) $page = "1";

if ($page <= 0) $page="1";



?>




include("config.php");



if (isset($_POST['username']) && isset($_POST['password']) && isset($_POST['email']))



 



{



//Prevent SQL injections



$username = mysql_real_escape_string($_POST['username']);



$email = mysql_real_escape_string($_POST['email']);



 



 



//Get MD5 hash of password



$password = md5($_POST['password']);



 



//Check to see if username exists



$sql = mysql_query("SELECT username FROM usersystem WHERE username = 'username'");



if (mysql_num_rows($s>0))



{



die ("Username taken.");



}



 



 



mysql_query("INSERT INTO usersystem (username, password, email) VALUES ( '$username', '$password', '$email')") or die (mysql_error()); echo "Account created."; 



 



}



?>



 











Username: 



Password: 



Email:




include("config.php");



if (isset($_POST['username']) && isset($_POST['password']))



{    



user_login($_POST['username'], $_POST['password']);



}



?>











Username: 



Password:

Hotel Room Reservation System

Donno_db2 — Sat, 05 Dec 2009 16:45:13 GMT

I need help here anyone can give me heads up will be appreciated

Hotel Room Reservation System
Westin owns a chain of hotels internationally around the world. As a world renowned hotel, it is their priority to ensure the efficiency of their services. As a means to improve their services, they hire you to develop a database for their hotel room reservation. The database system should be able to keep track on reservation details, rooms and customer information.
Each hotel of Westin offers a standardised accommodation package. Each hotel has anywhere from twenty to one hundred rooms . These rooms could be either Standard type, Deluxe type, Superior type or Family type. Some rooms are facing good views while some are without any view. All rooms are cater for two or more adults, and are charged on a room per night basis, regardless of whether they are occupied by one or two guests. The charge per room per night is standard throughout the week . However, each room may have many different room facilities. A customer can make several reservations.
Nevertheless, a room can only be subject to one reservation, on a given day, at any given time. A reservation may involve one or more rooms. However, all rooms in a s ingle reservation must have the same arrival and departure dates. If different arrival dates apply then separate reservations must be made. Each single reservation is made in a single name regardless of how many guests it actually involves. When a reservation is made the room allocated should always be the room whose vacant period best matches the requested reservation period, given that the room is of the type requested. The cus tomer needs to pay during the reservation, whereby the total prices are calculated based on number of room reserved per night. As a token of appreciation, Westin offers a 10% discount to regular customer (customer whic h has stayed in any chain of hotels for more than 10 times in a year).

Example SQL queries and statements that your databas e should be able to handle
•List the available rooms group by their room types
•List the chain of Westin hotels which has the most number of reservations.
•Create report(s) to list the total number of reservations for each day/month/year for each chain of Westin hotels .
•For each hotel, list the top five countries from where the customer originates from.
•Create a trigger that will price a room at a disc ounted rate for rooms that had their reservations cancelled. You may set the discount at different rates depending on the days (e.g. 1 week before actual date = 20% discount, 1 day before 50% discount). This is to encourage people to take up empty rooms and ensure that no room in the hotel is left empty (full occupancy = more money!)
•Create a trigger that will automatically identify which c ustomer are the regular customers which will receive coupons for special offers.

e r diagram help for either time table generation r info retrieval system

aayush88 — Sat, 05 Dec 2009 05:16:45 GMT

i hv gt a project on time table information retrieval system with oracle as the back edn and vb as the front end so i woul d be really grateful if anyone could help me with the er diagram for time table .
the entitites are faculty ,course which has a lab component then class room info andtime slot as the main entity

Database attaches as read-only, writes up permissions too

konczuras — Fri, 04 Dec 2009 22:02:00 GMT

Hello, I've got some weird database issue, and I can't figure it out myself, so I'd like to ask for your help.
My problem is the following:

I've a working ASP.NET solution which relies on a MSSQL 2008 database, Express Edition. Now, I'm working on a WPF version of the same app, so I've copied an instance of the database to my development machine, for testing my developing app in real-world circumstances.

It had worked for a while, but recently, after copying the database again (like I did quite a lot of times), suddenly I wasn't able to modify the database, and got the error message, when I tried to modify it, running the app from Visual Studio:

Quote:

Failed to update database "C:\SQL\PARADATA.MDF" because the database is read-only.

I'm attaching it form my app. First, I checked the access rights, and granted full rights to everybody (just to make sure it works). Now, when I attached again, got the same error message, went back to the access rights, and noticed that my recently added rights were gone. I run another circle, and the same thing happened.

I'm not able to modify it from SSMS also, first it shows up as a read-only database (grayed out), then, when I set it to writable, update it, and nothing happens, but I don't receive any error message in this case.

So, if anyone would be able to help, I'd really appreciate it. But the key issue here is (as I think) what happened between two usual database copy-paste which had caused this..
Any suggestions?

Thanks in advance!

SQL Error Maessage when executing INSERT

GTR3521 — Fri, 04 Dec 2009 20:20:27 GMT

This is my database it executes with no error.

--Kudler Fine Food Database

Create Database [VALMKudler_Fine_Foods]

On Primary

     (NAME=VALM_KudlerDB,

          FileName="C:\POS410\VALM_KudlerDB_dat.mdf",

          SIZE=10MB,

          MAXSIZE=100MB,

          FILEGROWTH=10%)

--Kudler Fine Foods

LOG ON 

     (NAME="VALM_KudlerDB_log",

           FILENAME="C:\POS410\VALM_KudlerDB_log.Idf",

           SIZE=5MB,

           MAXSIZE=100MB,

           FILEGROWTH=20%)

This is my table it executes with no problems

--Job Tittle Table 

     CREATE TABLE [VALMKudler_Fine_Foods].dbo.tbljobtitle

     ( jobID Int CONSTRAINT PK_jobID PRIMARY KEY Not Null,

       jobEEO_1Class char(40) Not Null,

       jobTitle char(40) Not Null,

       jobDesc char(300) Not Null,

       jobExempt_NonExe char(20) Not Null)

]

This is the insert I'm trying to execute but it keep coming up with errors.

--Accounting Clerk

INSERT INTO[VALMKudler_Fine_Foods].dbo.tbljobtitle

(

[jobID],

[jobEEO_1Class],

[jobTitle],

[jobDesc],

[jobExempt_NonExe]

)

VALUES(

'2000',

'Office/Clerical',

'Accounting Clerk'

'Computes, classifies, records, verifies numerical data for use in maintaining

accounting records.',

'Non Exempt'

)



--Assistant Manager 

INSERT INTO[VALMKudler_Fine_Foods].dbo.tbljobtitle

(

[jobID],

[jobEEO_1Class],

[jobTitle],

[jobDesc],

[jobExempt_NonExe]

)

VALUES(

'2010',

'office/Clerical',

'Assistant Manager',

'Supervises and coordinates activities of workers in department of food store.

Assists store manager in daily operations of store.',

'Exempt'

)

And here is the error message:

Error Message:

Msg 102, Level 15, State 1, Line 2
Incorrect syntax near ']'.
Msg 102, Level 15, State 1, Line 51
Incorrect syntax near 'Places customer orders in bags. Performs carryout duties for customers.'.

No matter what I try I still get an error message when I try to execute my inserts. I'll take any suggestions or ideas!

Thanks

PL/SQL

sandyzden — Fri, 04 Dec 2009 16:46:26 GMT

which version of MYSQL do support PL/SQL

how to updete field for a set of records from one record in the same table?

Teofil — Fri, 04 Dec 2009 13:16:24 GMT

I would like to update 2 fields values from one record to a set of records in the same table:

I tryed this:

UPDATE dd SET dd.comment = y.comment, dd.author = y. author

FROM Table1 dd LEFT OUTER JOIN

(SELECT * FROM Table1 WHERE Idx=1234) y

ON dd.vin = y.vin

WHERE dd.vin like '%WLS%'

vin and idx fields are unique keys
My desire is to have the fields comment and author updated from the record which has idx=1234 to all the records whic contain in field vin 'WLS' string.
thanks in advance

insert pictures

jrosh — Fri, 04 Dec 2009 09:28:11 GMT

How to write the query to insert a picture to mysql data field which is declared as BLOB.

I would like to knw the pure sql query with out any involvement of a programing language.(If there is such)

Thankx in advance.

Adding an Identity Later T-SQL

vuyiswamb — Fri, 04 Dec 2009 08:20:23 GMT

Good Day All

i have a Table with the ID Field that was not an identity Field. This Field has not Duplicates. Now later i want to Change this numeric Field as an Identity Field like this

--STEP 7 ADD THE IDENTITY BACK IN TABLE MTM_ACTV_STAFF

ALTER TABLE [New_Jaco].[dbo].[MTM_ACTV_STAFF]

ALTER COLUMN [ID] IDENTITY(1,1)

but i get an Error that says

Quote:

Msg 156, Level 15, State 1, Line 3
Incorrect syntax near the keyword 'IDENTITY'.

choice of join?!

lifeworks — Fri, 04 Dec 2009 08:04:25 GMT

Hi

Trying to pull this off in one query but my and right & left joining is giving me unusual results...

i have a 'product_style' table, an 'product_item' table, an 'addto' table and a 'removefrom' table - im monitoring when products are added/removed to/from the cart... and want to pull a report for each product on how many times they're added, removed...

the link goes product -> item ->add_to/remove_from ie. the add_to, remove_from table records items, and each item is associated to a product_style...

my latest try was:

$sql = "SELECT s.name,COUNT(a.id),COUNT(r.id) FROM product_items AS i 

LEFT JOIN watch_addtocart AS a ON a.id = i.id 

LEFT JOIN watch_removefromcart AS r ON r.id = i.id 

LEFT JOIN product_styles AS s ON s.id = i.product_style_id 

GROUP BY i.product_style_id";

but theres only one record in the addto table, and it produces 2 or 3 for random product...?!

Why this doesn't work?

leokuz — Fri, 04 Dec 2009 02:10:41 GMT

In MySQL I have created database "mydata" with the table "contacts". The fields are as follow:

ID (Primary Key) (INT(10)
Name VARCHAR(45)
Title VARCHAR(45)
Address VARCHAR(45)
Comments TEXT

Based on info at http://www.webmasterforums.com/php-d...-database.html I have created following two files:

new_record.php


    $usr = "myusername"; 

    $pwd = "mypassword"; 

    $db = "mydata"; 

    $host = "localhost"; 



    # connect to database 

    $cid = mysql_connect($host,$usr,$pwd); 

    mysql_select_db($db); 

    if (mysql_error()) { print "Database ERROR: " . mysql_error(); } 



?> 

 

 

Insert New Record 

 

 



Insert New Record
 




    # this is processed when the form is submitted 

    # back on to this page (POST METHOD) 

    if ($_SERVER['REQUEST_METHOD'] == "POST")  

    { 

        # escape data and set variables 

        $Name = addslashes($_POST["Name"]); 

        $Title = addslashes($_POST["Title"]); 

        $Address = addslashes($_POST["Address"]); 

        $NOTES = addslashes($_POST["Comments"]); 



        # setup SQL statement 

$sql  = " INSERT INTO contacts "; 

$sql .= " (Name, Title, Address, Comments) VALUES "; 

$sql .= " ('$Name','$Title','$Address','$Notes') "; 



        #execute SQL statement 

        $result = mysql_query($sql, $cid); 



        # check for error 

        if (mysql_error()) { print "Database ERROR: " . mysql_error(); } 



print "New Job Added  - View it HERE
"; 

} 



?> 



          

                                                                                                             

      

      

    

    

      

    Name:  
Title:  
Address:  
 Comments:

and

show_last_record.php


    $usr = "myusername"; 

    $pwd = "mypassword"; 

    $db = "mydata"; 

    $host = "localhost"; 



    # connect to database 

    $cid = mysql_connect($host,$usr,$pwd); 

    mysql_select_db($db); 

    if (mysql_error()) { print "Database ERROR: " . mysql_error(); } 



?> 

 

 

This is Your New Record 

 

 




function drawtable($qr) { 

    // $qr = results of a mysql_query 

    $rows = mysql_num_rows($qr); 

    $toreturn = "\n"; 

    $toreturn .= "\n"; 

    for ($i=0; $i
        $toreturn .= "\t\n"; 

        } 

    $toreturn .= "\n"; 

    for ($i=0; $i<$rows; $i++) {  

        $row = mysql_fetch_row($qr); 

        $cols = sizeof($row); 

        $toreturn .= "\n"; 

        for ($x=0; $x < $cols; $x++) { 

            if ($row[$x]==NULL){ 

                $row[$x]=' '; 

                } 

            $toreturn .= "\t\n"; 

            } 

        $toreturn .= "\n"; 

        } 

    $toreturn .= '".mysql_field_name($qr,$i)."
$row[$x]
'; 

    return $toreturn; 

    } 

$q = stripslashes($_POST['q']); 

if (empty($q)) { 

    $q = 'select Name, Title from contacts order by Name desc limit 1;'; 

    } 

mysql_select_db("mydata"); 

$result = mysql_query($q); 



print "Your New Record Has Been Added\n"; 



echo drawtable($result); 

echo '
 
 

 

';

".mysql_field_name($qr,$i)."
$row[$x]

I use IIS 7 and IIS 6 and put both of these files to C:\inetpub\wwwroot. The form displays correctly in IE8. However, clicking "Add Record" button, makes data typed into the fields disappear with nothing else happening. No lastly added record shows up, and worst of all, no record is being entered into database at all. There are no errors either.

What do I do wrong? I am quiet new to MySQL and PHP.

Importing .sql file into mysql - linux

nonshatter — Thu, 03 Dec 2009 20:11:04 GMT

Before I begin i'm sorry if this is a noobish question. Basically I'm trying to import a 'forum.sql' file into mysql so that I can access and manipulate it through a Java servlet.

The path to the sql dump file is /home/floyd/Desktop/forum/forum.sql so i open a terminal window, cd into that directory and type:

floyd@floyd:~/Desktop/forum$mysql -u root -p root forum < forum.sql

Then i get this...

mysql Ver 14.12 Distrib 5.0.67, for debian-linux-gnu (x86_64) using readline 5.2
Copyright (C) 2000-2008 MySQL AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license
Usage: mysql [OPTIONS] [database]
-?, --help Display this help and exit.
-I, --help Synonym for -?
--auto-rehash Enable automatic rehashing. One doesn't need to use
'rehash' to get table and field completion, but startup
and reconnecting may take a longer time. Disable with
--disable-auto-rehash.
-A, --no-auto-rehash
No automatic rehashing. One has to use 'rehash' to get
table and field completion. This gives a quicker start of
mysql and disables rehashing on reconnect. WARNING:
options deprecated; use --disable-auto-rehash instead.
-B, --batch Don't use history file. Disable interactive behavior.
(Enables --silent)

....................................

auto-rehash TRUE
character-sets-dir (No default value)
default-character-set latin1
comments FALSE
compress FALSE
database (No default value)
delimiter ;
vertical FALSE
force FALSE

...................................

max_join_size 1000000
secure-auth FALSE
show-warnings FALSE
floyd@floyd:~/Desktop/forum$

Then I start mysql and try and view the database but the database is not there...

floyd@floyd:~/Desktop/forum$ mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 42
Server version: 5.0.67-0ubuntu6 (Ubuntu)

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
+--------------------+
1 row in set (0.00 sec)

Where do I go from here? How can I actually be sure the database has or hasn't been imported? How to view the database so i know what fields i need to access?!?

Any help is much appreciated,
Many thanks

sql Examples

saher_omer — Thu, 03 Dec 2009 17:45:16 GMT

Hello All
:pretty:
i m new in this forum and i want to ask if there is examples about sql
bcz i have lab exam on sunday and i don't know the type of questions so i m friad from that :S
i use Oracle Sql*plus
and thanx alot 4 every one can help me

:)

MSAcs> How do I UPDATE a table using the data from MULTIPLE TABLES?

airpricing — Thu, 03 Dec 2009 17:19:13 GMT

I am using MS ACCESS, and have 4 tables to update, from 2 different tables/spreadsheet

Where table

tb1- Client Index, Name, address and zip.
tb2- user index, Sales rep, client index
tb3- user index, Managers
tb4- client index, Sales Target

Master 1 has Name, address, Sales target and sales rep
Master 2 has Name, manager, zip

So, I need UPDATE the records as per:
From master 1 to tb1 with the client index (auto increment), name, details.

From master 1 to tb2, salesrep, tb1.clientindex,
where tb1.name=master2.name if not found, create a new record
update tb2 set clientindex=tb1.clientindex,
update tb2 set salesrep=master1.salesrep

From master 1 to tb4, target, tb1.clientindex,
where tb1.name=master2.name if not found, create a new record
update tb4 set clientindex=tb1.clientindex,
update tb4 set target=master1.target

From master 2 to tb1, target, tb1.clientindex,
where tb1.name=master2.name if not found, create a new record

From master 2 to tb3, manager,
where tb1.name=master2.name
and
update tb3
set index=tb1.index
set manager=master2.manager

The idea is the above, but.. Can anyone help me with this? (translating into a MSACCESS/SQL entry)
I am sorry.. it is a bit complicated, and it seems to be a bit too much for a noob!!!

database suggestions

scias23 — Thu, 03 Dec 2009 14:59:57 GMT

last semester, i did an airline reservation system. we need to create another system for this semester. any suggestions? [except inventory and enrollment systems]

thanks

mysql and C++

xagutxu — Thu, 03 Dec 2009 12:39:07 GMT

Hi!

I am trying to implement a server-cgi with C++, but I don't know which is the best way for the cgi to communicate with the mysql server.

In the mysql web, I have seen that there are "connectors", but I don't really know which is their functionallity. Should I try with the libs and "mysql.h" header file, or should I install a "mysql C++/connector"?

Thank you,

Xagutxu

Catastrophic failure - Number: -2147418113

Blake98 — Thu, 03 Dec 2009 11:35:35 GMT

Hi i need some help. i am trying to run a process that will move records from one table to the other and i am getting this error msg " Description: Catastrophic failure - Number: -2147418113" in the detailed error log but on the interface m getting something like

Error Occurred in:
frmRT05GMC_DelSel.cmbDelete_Click
Description
Number0
Query SQL: Select SYSTEM_RECORD_NO,GPNational, Pshipcode,GPGMC, Agencycipher From FROM GMS_DYNAMIC_GMS_RT05SEP2009
FileName
See Application error log to view this msg in full

A bit background
I have an access database as the frontend for an Oracle database, if i change the setting to a different month say Mar (March) its working fine but if i change the month to run on Sep (September) data its falling apart: the way i m changing the dates is by ticking and some manually within the code (have double checked this) part of the code thats problematic is as below

Option Compare Database

Option Explicit

Dim msFilter As String

Dim mbFirstTime As Boolean



Private Sub cmbDelete_Click()

On Error GoTo Err_cmbDelete_Click



Dim sql As String

Dim cnt As Long

Dim maxCnt As Long

Dim oLvw As ListView

Dim oLvwItem As ListItem

Set oLvw = Me.lvwSelection.Object

Dim bInTrans As Boolean

Dim iRecAffected As Integer



If oLvw.ListItems.Count = 0 Then

    MsgBox "There are no records to delete", vbExclamation, "GMS"

    Exit Sub

End If

    

If MsgBox("Are you sure you want to delete these records", vbQuestion + vbDefaultButton2 + vbYesNo, "GMS") = vbNo Then Exit Sub

DoEvents

For Each oLvwItem In oLvw.ListItems

    If oLvwItem.Checked = True Then

        maxCnt = maxCnt + 1

    End If

Next



Dim oCon As clsOracleCon

Dim rs As ADODB.Recordset

Set oCon = New clsOracleCon



DoCmd.Hourglass True



oCon.conn.Open



For Each oLvwItem In oLvw.ListItems

    If oLvwItem.Checked = True Then

        

        

        sql = "Select System_Record_No,GPNational,PSHIPCODE,GPGMC,AgencyCipher from " & GetTableName("5") & " where System_Record_No=" & oLvwItem

        

        Set rs = oCon.conn.Execute(sql)

        If Not rs.EOF Then

            'if there is a GP National code then try test for the presence of records in

            'rt 07,09 and 12

            oCon.conn.BeginTrans

            bInTrans = True

            

            If Nz(rs.Fields("GPNational").value, "") <> "" And Nz(rs.Fields("AgencyCipher").value, "") <> "" Then

                If Not MoveRT57912ToXX(oCon.conn, "5", "xx5", "System_Record_No", rs.Fields("SYSTEM_RECORD_NO").value, "GPNational", rs.Fields("GPNational").value, rs.Fields("AgencyCipher").value) Then

                    GoTo Rollback

                End If

                If rs.Fields("GPNational").value <> 0 Then  'tables linked by GPNational

                    If Not MoveRT57912ToXX(oCon.conn, "7", "xx7", "GPNational", Nz(rs.Fields("GPNational").value, ""), "PSHIPCODE", rs.Fields("PSHIPCODE").value, rs.Fields("AgencyCipher").value) Then

                        GoTo Rollback

                    End If

                    If Not MoveRT57912ToXX(oCon.conn, "9", "xx9", "GPNational", Nz(rs.Fields("GPNational").value, ""), "PSHIPCODE", rs.Fields("PSHIPCODE").value, rs.Fields("AgencyCipher").value) Then

                        GoTo Rollback

                    End If

                    If Not MoveRT57912ToXX(oCon.conn, "12", "xx12", "GPNational", Nz(rs.Fields("GPNational").value, ""), "PARTNERSHIPCODE", rs.Fields("PSHIPCODE").value, rs.Fields("AgencyCipher").value) Then

                        GoTo Rollback

                    End If

                End If

            End If

            

            'Commit changes

            oCon.conn.CommitTrans

            bInTrans = False

        

            

            cnt = cnt + 1

            

        End If

        Set rs = Nothing

        

        If cnt Mod 10 = 0 Then

            Me.lblStatus.Caption = "Moved " & cnt & " of " & maxCnt & " to the XX tables. Please wait"

            DoEvents

        End If

        

        

    End If

Next



Me.lblStatus.Caption = "Moved " & cnt & " of " & maxCnt & " to the XX tables"

DoEvents

cmbLoad_Click



Exit_cmbDelete_Click:

DoCmd.Hourglass False

If Not oCon Is Nothing Then

    oCon.KillConn

    Set oCon = Nothing

End If



Exit Sub



Err_cmbDelete_Click:

    If bInTrans = True Then

        oCon.conn.RollbackTrans

        bInTrans = False

    End If

    

    DoCmd.Hourglass False

    Errortrap True, err, Me.Name, "cmbDelete_Click", "", sql

    Resume 'Exit_cmbDelete_Click

    

Rollback:

If bInTrans Then

    oCon.conn.RollbackTrans

    DoCmd.Hourglass False

    MsgBox "There was an error and some records were not moved to the xx tables. See application log", vbCritical, "GMS"

    GoTo Exit_cmbDelete_Click

End If

End Sub



Private Sub cmbLoad_Click()

On Error GoTo Err_cmbLoad_Click



Dim sql As String

Dim sFilter As String



If msFilter <> "" Then

    sFilter = "AND MA.AgencyCipher in (" & msFilter & ") "

Else

    sFilter = ""

End If



Me.lblStatus.Caption = "."



Dim sChecked As String

Dim sSetting As String

sSetting = "Checkbox settings " & Me.Name



If Not mbFirstTime Then

    'remember checked boxes

    sChecked = GetCheckedBoxList(Me.lvwSelection.Object)

    modSettings.SetSettingLocal sSetting, sChecked, "Form Setting", True

Else

    mbFirstTime = False

    sChecked = modSettings.GetSettingLocal(sSetting, "")

End If



sql = "SELECT A.System_Record_No AS ID,A.AgencyCipher, A.GPGMC,A.GPNational," & _

" A.GPSURNAME , " & _

"A.GPINITIALS , " & _

"A.GPSEX,A.GPCATEGORYSTAT , " & _

"A.PSHIPCODE, A.PCGPCTNATIONALCODE " & _

"FROM  " & GetTableName("5") & " A " & _

"LEFT JOIN " & GetTableName("EMPFILE") & " E ON A.GPGMC = E.GMC_NUMBER " & _

" WHERE E.GMC_Number is null " & sFilter





Dim oCon As clsOracleCon

Dim rs As ADODB.Recordset

Set oCon = New clsOracleCon



DoCmd.Hourglass True



oCon.conn.Open

Set rs = oCon.conn.Execute(sql)



PopulateListViewADO rs, Me.lvwSelection.Object



SetCheckedBoxList Me.lvwSelection.Object, sChecked



Exit_cmbLoad_Click:

DoCmd.Hourglass False

If Not oCon Is Nothing Then

    oCon.KillConn

    Set oCon = Nothing

End If

Exit Sub



Err_cmbLoad_Click:

    DoCmd.Hourglass False

    Errortrap True, err, Me.Name, "cmbLoad_Click", "", sql

    Resume Exit_cmbLoad_Click

    

End Sub



Private Sub cmbSelectAll_Click()

Dim oLvw As MSComctlLib.ListView

Set oLvw = Me.lvwSelection.Object

Dim oLvwItem As MSComctlLib.ListItem



    If oLvw.ListItems.Count = 0 Then

        Exit Sub

    End If

    

    For Each oLvwItem In oLvw.ListItems

        If Me.cmbSelectAll.Caption = "De-Select All" Then

            oLvwItem.Checked = False

        Else

            oLvwItem.Checked = True

        End If

    Next

        

    If Me.cmbSelectAll.Caption = "De-Select All" Then

       Me.cmbSelectAll.Caption = "Select All"

    Else

       Me.cmbSelectAll.Caption = "De-Select All"

    End If

    

    Set oLvw = Nothing





End Sub



Private Sub cmbSelectStatus7810_Click()

Dim oLvw As MSComctlLib.ListView

Set oLvw = Me.lvwSelection.Object

Dim oLvwItem As MSComctlLib.ListItem



    If oLvw.ListItems.Count = 0 Then

        Exit Sub

    End If

    

    For Each oLvwItem In oLvw.ListItems

        If oLvwItem.SubItems(7) = 7 Or oLvwItem.SubItems(7) = 8 Or oLvwItem.SubItems(7) = 10 Then

            oLvwItem.Checked = True

        Else

            oLvwItem.Checked = False

        End If

    Next

    

    Set oLvw = Nothing



End Sub



Private Sub Form_Close()

Dim sChecked As String

Dim sSetting As String

sSetting = "Checkbox settings " & Me.Name

sChecked = GetCheckedBoxList(Me.lvwSelection.Object)

modSettings.SetSettingLocal sSetting, sChecked, "Form Setting", True

End Sub



Private Sub Form_Load()

DoCmd.Maximize

mbFirstTime = True

cmbLoad_Click

End Sub



Private Sub Form_Open(Cancel As Integer)

msFilter = Me.OpenArgs

ClearListview Me.lvwSelection.Object

If msFilter <> "" Then

Else

    MsgBox "Please re-open this form to re-set the filter", vbExclamation, "GMS"

    Cancel = True

    Exit Sub

End If

End Sub



Private Sub lvwSelection_ColumnClick(ByVal ColumnHeader As Object)

Dim oListView As ListView

    Dim oColumn As ColumnHeader

    Dim oColumnSort As ColumnHeader

    

    If ShowListOptionDialog(Me.lvwSelection.Object, ColumnHeader) = "reorder" Then

    

        Set oListView = Me.lvwSelection.Object

        For Each oColumn In oListView.ColumnHeaders

            If oColumn.Key = ColumnHeader.Key & "SORT" Then

                Set oColumnSort = oColumn

                Exit For

            End If

        Next oColumn

        

        If oColumnSort Is Nothing Then

            Set oColumnSort = ColumnHeader

        End If

        

        If oListView.SortKey = oColumnSort.Index - 1 Then

            oListView.Sorted = True

            If oListView.SortOrder = lvwAscending Then

                oListView.SortOrder = lvwDescending

            Else

                oListView.SortOrder = lvwAscending

            End If

        Else

            oListView.Sorted = True

            oListView.SortKey = oColumnSort.Index - 1

            oListView.SortOrder = lvwAscending

        End If

    End If

    

    Set oListView = Nothing

    Set oColumn = Nothing

    Set oColumnSort = Nothing

End Sub



Private Sub cmbUnselectAll_Click()

On Error GoTo Err_cmbUnselectAll_Click





    Screen.PreviousControl.SetFocus

    DoCmd.FindNext



Exit_cmbUnselectAll_Click:

    Exit Sub



Err_cmbUnselectAll_Click:

    MsgBox err.Description

    Resume Exit_cmbUnselectAll_Click

    

End Sub

Indexes?

smartness — Wed, 02 Dec 2009 19:57:19 GMT

this is my table:

CREATE TABLE IF NOT EXISTS `artikulli` (

  `id` int(11) NOT NULL AUTO_INCREMENT,

  `autori` varchar(100) CHARACTER SET utf8 NOT NULL,

  `perkthyesi` varchar(100) CHARACTER SET utf8 NOT NULL,

  `category` varchar(100) CHARACTER SET utf8 NOT NULL,

  `titulli` varchar(350) CHARACTER SET latin1 NOT NULL,

  `nen_titulli` varchar(400) CHARACTER SET utf8 NOT NULL,

  `url_alias` varchar(400) COLLATE utf8_unicode_ci NOT NULL,

  `burimi` varchar(200) CHARACTER SET utf8 NOT NULL,

  `teksti` text CHARACTER SET latin1 NOT NULL,

  `intro` text COLLATE utf8_unicode_ci NOT NULL,

  `picture` varchar(500) COLLATE utf8_unicode_ci NOT NULL,

  `date` int(11) NOT NULL,

  `views` int(10) NOT NULL,

  `is_perhershme` int(10) NOT NULL,

  `etiketat` varchar(500) CHARACTER SET utf8 NOT NULL DEFAULT '',

  `featured` tinyint(10) NOT NULL,

  `ft_order` int(10) NOT NULL,

  `show_picture` int(10) NOT NULL DEFAULT '1',

  PRIMARY KEY (`id`)

) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=51 ;

id is the unique Id of each article, i get articles with $_GET['id'];

so is this the right field to create index?

SQL Function

Tank50 — Wed, 02 Dec 2009 17:34:43 GMT

I use SQL Server 2005 and I create function.Below I mention the Function that I created.

CREATE FUNCTION dbo.udf_GetCountryID(@Name varchar(50))

RETURNS VARCHAR(1000) AS



BEGIN

Declare @Description varchar(4000)

select @Description = coalesce(@Description + ',' , '' ) +  countryCode 

FROM dbo.Test_Table where CommonName='Japan'



Return @Description

END

After creating function I use below SQL statement

select dbo.udf_GetCountryID(Distinct(F.CommonName))CountryName from dbo.Test_Table F

but I got the Error message.Below I mention the error message also
Msg 208, Level 16, State 101, Line 1
Invalid object name 'dbo.udf_GetCountryID'.

Once I create the function its comes under scalar-valued function.I am using sql server 2005.Please help me

Thanks
Tank50

ER Help Pls

dwaynecaine — Wed, 02 Dec 2009 15:23:27 GMT

Ok i wa swondering if i could get help on this:

Jack’s Jail is a new private facility set up to cash in on the current shortage of prison places. The jail is to be set up in Manchester using some old buildings that are surplus to requirements (so some of the inmates could be familiar with the layout of their new accommodation!).
The Jail is planned to have 643 cells – each cell has a wing letter (A-D), level (1 to 4) and cell number (two digits). Of these cells, 220 can be shared cells (double occupancy – if there is the need) and 43, of the single occupancy cells, are suitable for high surveillance and can be used for ‘at risk’ prisoners. There is also an isolation block (wing E, level 1, 20 cells) where prisoners on punishment can be transferred for periods of between two and 10 days.
To run his jail, Jack needs a ‘hotel system’ to keep track of the inmates. The system will need to book-in the prisoners when they arrive (record their name, prisoner number, date of admission (i.e. start of sentence), length of sentence (in days), category (A to D) and whether they are considered ‘at risk’. Prisoners with ‘at risk’ status also have details recorded of the nature of that risk, e.g. danger of suicide. As well as recording the prisoner’s details the book-in process has to allocate a suitable cell (taking into account their status (category A and B can not share a cell) and whether they are ‘at risk’).
Once booked in the prisoner details can be amended. They may receive remission (days to be deducted from their sentence) and this must be added to their record.
Prisoners can also be put ‘on punishment’ in which case they are allocated to a cell on wing E for the duration of the punishment (their original cell allocation is retained and they return there at the end of the punishment period). Each punishment is recorded on the prisoner’s record with the offence title, punishment start date and duration; details of the punishment are retained and can be taken into account if further offences occur.
The system needs also needs to make sure that prisoners are released on time. Each week there is a report listing prisoners to be released the following week (calculated from: date of admission + length of sentence – remission). When the prisoner is released the release date is added to their record (and obviously their cell becomes free and available for new inmates).

Struggling to get the relationships between each entity i'll be gratefull if anyone could help

searching problem in SQL server 2005

mm4215 — Wed, 02 Dec 2009 11:57:59 GMT

hai all

i am facing some problem in SQL.I am searching the one string(ex.roll-over) in table
its returning wrong results.
my table contains,

dable datas
table_1 is table name
number1 text1
1 notify us the day you roll check over.
2 notify us theday you roll check .
3 notify us the day you roll check roll-over.
4 notify us the day you roll check roll over.

my query is
select * from table_1 WHERE CONTAINS(text1, '"roll-over"')
select * from table_1 WHERE CONTAINS(text1, 'roll-over')

in both case i am getting below results.
results
number1 text1
1 notify us the day you roll check over.
2 notify us theday you roll check .
3 notify us the day you roll check roll-over.
4 notify us the day you roll check roll over.

here it should return only one result insted of four.
is there any thing wrong in Query if not can any one help to from the correct query.
i think Bcoz os hyphen the result is returinig either roll or over presents.

thanks
mahe

MS Access (1 to Many) Table Definition

chuckc — Wed, 02 Dec 2009 01:04:23 GMT

In defining MS Access tables where a 1 to many relation exists what is the best way to define a table containing the “many” records. For example, a database with orders and line-items might have the “line item” table with an order-number and a line-number which would define a unique record. Is there a way to create a compound primary key for this with Access 2000?

Since duplicates are allowed, the order number itself can not be a primary key of the line item table, so is it necessary to have a “primary key” or would it be reasonable for such a table not to have a primary key?

Or is it better to simply add an auto-number field to the table?

Change from a Mysql database

asmikwen — Tue, 01 Dec 2009 15:12:42 GMT

Hello,

We are currently using a Mysql database: we would like to change. Now, we'd like to use Mssql. Only problem is that most of the data and other information are on Mysql. Can you help us with this?

Thanks a lot for your help.

Search for numeric values from a varchar field in SQL server

renu_kj — Tue, 01 Dec 2009 14:21:22 GMT

Hi

I have a column named 'ExtRefNo' which of varchar datatype.
The values can be numbers alone(eg; 101) & values comprising characters & numbers(eg:101A3)

My requirement is if the user search for ExtRefNo between 100 & 105,
it shud retrieve all ExtRefNos ranging from 100,101,102,103,104 & 105.
Need not include the ExtRefNo, if it is 101A3.

I used Isnumeric() in a Case statement
Something like this..don't know the correct syntax

Case When Isnumeric(@FromContractExtRef2) = 1 and Isnumeric(@ToContractExtRef2) = 1
Then Cast(Contract.ExternalRef2 as int)
Else @FromContractExtRef2 End
Between ......

The Problem is that if the user search for ExtRefNo 101A3...it should only find the record that has got this ExtRefNo 101A3 , ie if the search values entered for @FromContractExtRef2 and @ToContractExtRef2 is numeric..then it should find all the ExtRefNo between that range..else should find the ExtRefNo which is like @FromContractExtRef2.

Hope this makes sense.

ER Diagram need help

hanzooi — Tue, 01 Dec 2009 10:50:14 GMT

A doctor may refer a patient to other doctors for treatment. A doctor must be referred by at least one other doctors.Each referral captures the referral date and description. Each referral is only for one patient. A patient may have any number of referrals.
(you must reflect which doctor refers a specific patient to another doctor in your data model.)

How to draw the relationship?
is it unary or tertiary relation?

by the way...if the supertype has just one subtype, how to draw on the ER diagram?

Creating Fact and Dimension Tables

toykwon5 — Tue, 01 Dec 2009 02:03:29 GMT

Hello,

I am new to Microsoft SQL Analysis service and am trying to create cubes. But, I understand that I first need to create fact and dimension tables.

How do I create them? I kinda know the relationship between those two (Maybe not) but I just don’t know how to create them. I have a relational database that contains tables which I can use to build fact and dimension tables.

I have data warehouse server. I understand that dimension and fact tables should be created in the data warehouse server.

Any help would be grateful.

Thanks!

Java database

emmas4impact — Mon, 30 Nov 2009 23:55:22 GMT

hello can someone help me out with these? am writing a project on a video rental store. and i have to use access i dont know if i should use one-many connection or many - many. if many-many then what will the code in the java database look like? remember the user have to know the movies in store the one rented and customer's name!
thanks

Enabling Network Connections?

blue-iguana — Mon, 30 Nov 2009 15:51:51 GMT

Hello,

When trying to use mysqldump, I got this error message:

Quote:

mysqldump: Got error: 2003: Can't connect to MySQL server on 'localhost' (10061) when trying to connect

According to the MySQL Documentation Library, error 2003 means that my network connection has been refused and that I should check that there is a MySQL server running, that it has network connections enabled, and that the network port specified is the one configured on the server.

Now MySQL is running as a service and is started on my machine. My Questions are:

1. How do I enable network connections?
2. How do I specify that the network port specified is the one configured on the server?

Any assistance will be really appreciated. Thanks in advance.

http://dev.mysql.com/doc/refman/5.1/en/can-not-connect-to-server.html

Database Table designs

kt123 — Mon, 30 Nov 2009 15:01:07 GMT

Hi all,

I have been set an assignment to which i have no clue about. I am going to paste the brief to you all and hopefully some kind person will give me some guidance upon what tables i need and what attributes need to go in them.

In a university environment there are members of staff and students. Some postgraduate students are also working as Research or Teaching Assistants and are, therefore, considered as members of staff as well. For each student we keep his or her name, library card number and degree programme they are studying. We are also keeping the course units they are studying and the grades that they get for each course unit. We also keep the School(s) that is/are responsible for each course unit. For each Research Assistant we keep his or her name, library card number and research project they are for. For each Teaching Assistant we keep his or her name, library card number and lecturer(s) that they are helping. For each academic member of staff we keep his or her name, library card number and course units they are responsible for. The university has a library. Each member of staff or student can borrow up to ten items from the library. These items are books, journals or technical reports. To each book the library is assigning a number and is also keeping the author(s), title and year that it was published. To each journal the library is assigning a number and is also keeping the title, volume and year that it was published. To each technical report the library is assigning a number and is keeping the author(s), title, version and year that it was published.

Thank you!

Need Help with EER Diagram and Tables

Tahseen79 — Mon, 30 Nov 2009 05:13:07 GMT

Hi I am taking MIS class and i need help with the EER diagram and i tried making it myself but teacher told me that it is a process diagram not an ER diagram please help me here is what i have tried: please click on this link http://yfrog.com/j2mytryj

and here is what another try here is the link http://yfrog.com/2s2ndxj

please let me know which one is correct i am having trouble defining the entities...and i also need to create table with attributes and normalize it...please help!

Here is the scenario:
MIS Corporation owns and operates nine large hardware stores and one centralized warehouse in major metropolitan areas of the west United States. The stores carry a wide variety of hardware merchandise for sale to the individual and business. The stock is stored in bins and is located by an inventory number in the warehouse.

Whenever a retail store needs merchandise, a four-part merchandise request form is completed. One copy is kept by the store, and three copies are mailed to the warehouse the next day. If the merchandise requested is on hand, the goods are delivered to the store, accompanied by the third copy of the request. The second copy is filed at the warehouse. The fourth copy is forward to accounts receivable for cost and revenue calculation.

If the quantity of goods on hand is not sufficient to fill the order, the warehouse sends the quantity available and notes the quantity shipped on the request form. A purchase memorandum for the shortage is then prepared by the warehouse. At the end of each day, all the memos are sent to the purchasing department.

When ordered goods are received, they are checked at the receiving area of the warehouse, and a receiving report is prepared. One copy of the receiving report is retained at the receiving area, one is forwarded to accounts payable, and one is filed at the warehouse with the purchase memorandum.

When the purchase memoranda are received from the warehouse, purchase orders are prepared. Vendor catalogs are used to select the best source for the requested goods, and the purchase order is prepared and mailed. Copies of the order are sent to account payable and the receiving area. One copy is retained in the purchasing department.

When receiving report arrives in the purchasing department, it is compared with the purchase order on file. It is also checked with the invoice before the invoice is forwarded to accounts payable for payment.

Each week a report of the open purchase orders is prepared to determine if any action should be taken on overdue deliveries. This report is prepared manually after scanning the file of outstanding purchase orders.

The company has been successful in this field. Each retail store acquires its merchandise from the company's centrally located warehouse. Consequently, the warehouse must maintain an up-to-date and well-stocked inventory ready to meet the demand of the individual stores.

The company wishes to hold its competitive position with similar stores of other companies in its market area. Therefore, MIS Company must improve its purchasing, inventory, and selling procedures. The number of company's store, the number of inventory items carried, and the volume of business has been providing pressures to change from basically manual data processing routines to a computerized processing system.

After several discussions with the company's executive board, Nancy Tsai, the chief executive office of MIS Company, has decided to install several minicomputers in stores and warehouse in the late 1990s. Most of the applications that have been installed on the computer are in the accounting and financial areas. Most of these application programs are purchased from a software vendor company that has modified the programs to meet the requirements of the MIS Company.

The computer applications at MIS Company have generally been successful. The software has enabled the company to reduce its paper work burden and improve its response to individual stores. In addition management is able to obtain better information concerning costs, sales, and profit.

Nevertheless, managers at MIS Company are dissatisfied with several aspects of the computer systems. While the applications have helped improved the operations management function, there has been little impact on middle management and still less on top management. Nancy Tsai and the other managers at MIS Company have come to realize that there are basic limitations to traditional file processing systems. Some of these limitations are (1) uncontrolled redundancy, (2) inconsistent data, (3) inflexibility, (4) limited data sharing, (5) poor enforcement of standards, and (6) excessive program maintenance.

Now the competition in hardware retailing has intensified. Competitors such as Home Base and Home Depot seem to response more rapidly than MIS Company to new business opportunities. Therefore, after analyzing the current individual file processing systems, the company's data processing consulting firm – the Oaks Associates has suggested replacing the existing systems with an integrated database management systems using Oracle.

The recommendation of the Oaks Associates stated that the new database management systems should have the following characteristics: (1) minimal data redundancy, (2) consistency of data, (3) integration of data, (4) sharing of data, (5) ease of application development, (6) uniform, security, privacy, and integrity controls, (7) data accessibility and responsiveness, (8) data independence, and (9) reduced program maintenance.

Nancy Tsai has accepted the excellent advice given by the Oaks Associates. She is intended to purchase Oracle as the MIS Company's database management systems. She has just hired your team for the data processing department. Your responsibility is to design a database oriented merchandise distribution systems to collect the information about inventory levels for the warehouse and individual stores, vendor, accounts payable, and accounts receivable. Nancy Tsai expects that your database design is flexible to handle both large volume transactional processing reports for the operation management and ad hoc reports for the top management.

===========
Please see the http://yfrog.com/06captureobp‏ document this is my new updated version please let me know if i have any mistakes as far as the tables and attributes and also the normalization
here is the tables
MIS Corporation
Attributes
CompanyID
Description

Hardware Stores
Attributes
StoreNo
StoreAdd
StorePhone
CustNo

Warehouse
Attributes
WarehouseNo
WarehouseAdd
WarehousePhone

Customers
Attributes
CustNo
CustLname
CustFname
CustAdd
CustPhone

Transactions
Attributes
TransNO
TransDate
ProductNO

Product
Attributes
ProductNo
ProductDescription
SerialNumber
Model Number

Purchase Order Item
Attributes
POINo
ProductNo
POIDescription
POIQuantaty
POIPrice
PurchaseNo

Purchase
Attributes
PurchaseNo
PurchaseDate
VendorNo
InvoiceNo
StaffNo
POINo

Vendor
Attributes
VendorNo
VendorAdd
VendorPhone
VendorType

Invoice
Attributes
InvoiceNo
InvoiceDate
InvoiceAmount
VendorNo
PurchaseNo

Payment
Attributes
PaymentNo
PaymentDate
PaymentAmount
VendorNo
PurchaseNo
InvoiceNo
StaffNo

Staff
Attributes
StafftNo
SLname
SFname
StoreNo
Hiredate
Saddress

Order
Attributes
OrderNo
OrderDate
CustomerNo
Cust_paymentNo
OLIno

Order Line Item
Attributes
OLineNo
ProductNo
OLineDescription
OLineQuantaty
OLinePrice
OrderNo

Cust_Payment
Attributes
Cust_PaymentNo
Cust_PaymentDate
Cust_PaymentAmount
StoreNo
OrderNo
StaffNo

Attached Files

	has1hireshires.pdf (31.5 KB)
	NEwTables.pdf (38.6 KB)

Need Help with EER Diagram

Tahseen79 — Mon, 30 Nov 2009 02:24:31 GMT

Querying for next and previous record info

dwlamb_001 — Sun, 29 Nov 2009 03:46:11 GMT

Much is written in various how-to sites about next and previous page navigation utilizing Limit to retrieve multiple rows of data and display them in chunks of 10 rows to a PHP page, as an example. This problem is subtly different.

For the site I am programming, all of the content for a given page is one record in a database. It is retrieved from the database using an id field. The Next Page/Previous Page navigation desired is to go to the record before or after the one currently displayed as a single web page.

The order by which these pages appear can vary based on sorting and other query criteria. It is a given that any query will return multiple rows. Presently, the data result returns data for url's used elsewhere on the page for navigation. The Next Page/Previous Page navigation is to supplement that.

How does one query the database to get the next or previous id of the id currently selected?

can’t load_file database

stacy220481 — Sun, 29 Nov 2009 02:38:35 GMT

I'm running as mysql root user on my system.

I can select load_file('/etc/passwd'); no problem

But when I try to select load_file('/var/lib/mysql/mysql'); I get NULL as a result why? this file is good, I can cat it as root and view the mysql user data, why cant mysql load_file it? Its permissions are the default:

-rw-rw---- 1 mysql mysql 444 2009-08-04 19:08 user.MYD

It's owner is by default the user mysql and has read permission, so why doesn't mysql like to load_file it? Is mysql somehow blocking access to this file and if so how can I bypass that? Doing stuff like mysql/../mysql in the path doesn't work, and using hex encoding didn't work either?

Help with query

ssa01 — Sat, 28 Nov 2009 00:38:17 GMT

Hi all,

I would like to ask for some help in a query. I am trying to create a view and this view should show the student name, project name, hours spent on the project, and number of units the project is worth. However, if the project is not done it should display null instead of the number of units available in the project database. I wrote the following query but can't get it to work

CREATE VIEW Student_A

AS SELECT  s.name, p.proj_name, a.hours, p.units, CASE p.units WHEN End_Date IS NOT NULL THEN p.units ELSE NULL END " Units"

From Student s, Project p, Assigned a

WHERE s.std_id=p.std_id AND p.project_id=a.project_id;

Any help is greatly appreciated =)

Hospital administration database

shariqmsit — Fri, 27 Nov 2009 12:42:32 GMT

DRIEND FRIENDS,
I am given a project "hospital administration database"
Could you please guide me how to start and proceed.
Thanks and Regards.
Shariq

Database Archiving

benkyma — Fri, 27 Nov 2009 10:48:20 GMT

I've got a database which is getting quite large and slow to query. I only really need the last month of entries for most situations so I'm looking to create structure-copies of two of my tables and then regularly move data from the 'live' two into the 'archive' two if the records are more than a month old.
What is the best way to achieve this? Should I regularly perform checks from my application (C#) or would it be better to let MySQL handle this operation?

Count on chars to match on another column

iann — Fri, 27 Nov 2009 00:50:54 GMT

Hi Guys

It may be friday, but I am having a real brain fade with this one.
I have one table which contains several columns (see below) I need to match names in the tables. The first name is in column childname1 which contains the full name, the column I need to match to is in "firstname" and "familyname" columns respectively.

I need a display the groupid beside the matching childname1 column. Now I can think of concatenating the first and family name columns to make it easier I can also think of doing it in excel, but I am looking for a count match on the first 3 letters of the firstname to the childname1 first name.
any ideas, have looked at pathindex and charindex to work it.!
groupid
093911982| NULL| Margaret| Johnston| Miss Grace Johnston|
037281982| NULL| Louise|Kelly|Ms Brianna Kelly|
083753534|NULL|Grace|Johnstone|NULL|

cheers

my clock to end postings does'nt work

gsc1ugs — Thu, 26 Nov 2009 10:35:37 GMT

Use this code

   sql = "SELECT products.endDate FROM products INNER JOIN "

   sql = sql & "                auctionevents ON products.idsupplier = auctionevents.idSupplier "

   sql = sql & "        WHERE     (products.endDate > CURRENT_TIMESTAMP) AND (auctionevents.ID = "&id&")  AND (products.ListHidden <> 1)"

but if the server is not run the endDate goes past currenttimestamp and continues forward, anyone help please?

Database Programming?

Garrett85 — Thu, 26 Nov 2009 06:30:18 GMT

I've been trying to learn how to program for several years now. I've struggled with everything from C++, C#, to Python, but never got passed simple DOS text based screen programs that were very short. I'M now 24 and I work in a factory. I would love to find a carer filed with computers, but I'll take anything with heat and air.
I've heard that database programming is an easier thing to learn that general programming and that there is money to be made.
So my question is, is SQL/MySQL the right place for me to be and get started? And how long much learning will it take to get a job? Thanks for any and all answers.

Store a photohraph in mysql

jrosh — Thu, 26 Nov 2009 04:44:39 GMT

Can I store a photograph in a mysql table. ?
What type it takes...how it is done.
Do i have to store only the path???
please explain me.

changed limits max_open_files warning in server

mahe4us — Thu, 26 Nov 2009 04:36:17 GMT

Hi,

we are running mysql 5.0.16-nt in windows 2003 server... we are getting frequently some warnings in the event viewer like
"Changed limits: max_open_files: 2048 max_connections: 450 table_cache: 794"
Once this warning arise, then the site has broken indicating "too many connections"..

I have gone through many of the threads posted in the net but I cant come to a solution and how to fix this problem..

Can you anybody give me suggestion for fix this problem?

Thanks

there is already an object named #instmsdb

ishaybas — Thu, 26 Nov 2009 02:47:50 GMT

Hi Gurus,

I am attempting to install KB970892 on SQL Express 2005SP3,
and I am unable to do so, due to a SQL suspended installation.

When I try to continue the installation (which I have no idea what is it trying to install - I have inherited this server the way it is), the following errors occur:

"there is already an object named 'sysmail_update_profileaccount_sp' in the database"

followed by

"there is already an object named #InstMsdb in the database"

and the installation is unable to continue from this point.

I have tried searching the web and forums but no answer ..

Any leads will be greatly appreciated!

Thank you,

-Ishay

Using

asmikwen — Wed, 25 Nov 2009 16:42:11 GMT

Hello to all,

We are currently using Excel and are thinking of changing. Now we would like to use Mysql. Only problem is that all our customer addresses and other information are on Excel.

Can you help us with this?

Thanks for your feedback.

(Of course title is bad... )

PHP and SQL to collate and print data (pdf format)

bigjoke — Wed, 25 Nov 2009 15:00:37 GMT

Hello and bonjour everyone

I need a bit of hand-holding (pseudo-code) on how to go about accomplishing this task and will appreciate it if you could find 1 or 2 minutes to guide me through.

Basically, i need to extract some information from database (different columns) and display it in a pdf format using php.

Now, i have never done this sort of thing before and was wondering if thats even realistically possible? What i was thinking was; create a new php file, say extracted_info.php, let it display the extracted information from different columns and even tables in one place and then somehow convert that information into a pdf file! Do you agree? what would i need to accomplish that. Quick googling churned up so many php and pdf library and tutorials but which one to choose? preferably the one built-in my PHP 5.x but i dont know even if its there!!

So, in short, any pointers no matter how trivial you think theya re will be very helpful as im kinda newbie in mixing SQL and PHP.

thanks in advance

Vacation days off

Amos76 — Wed, 25 Nov 2009 14:52:40 GMT

I am trying to capture the COUNT of employees who are off by running a query from a table that has employee name and START DATE and END DATE of their vacation days throughout the years. I need to pull all employees who are GONE over a period of DATES SELECTED by the user. Should I use a Y/N statement (GONE or NOT GONE) in the criteria? If so, what is it? Second, which search parameter should I use if I only have the START DATE and END DATE? I need to have something that will capture ALL employees who may have started or ended their vacations outside the dates selected for viewing by the user.

Thnks,
Amos

increase maximum number of result sets

cVz — Wed, 25 Nov 2009 12:56:38 GMT

I get the following message when executing a stored procedure.

The query has exceeded the maximum number of result sets that can be displayed in the results grid. Only the first 100 result sets are displayed in the grid.

However , i cannot change the fact that the SP uses a cursor.

Basically what happens is that the SP executes into a declared table, and then for each row it executes a new stored procedure bringing the number of result sets to about 20 000....

Any advice on where i can change this setting ?

Regards,

Scheduling Jobs in SQL Server 2005

farhan111 — Wed, 25 Nov 2009 10:13:39 GMT

PRACTICA EXAMPLE FOR Scheduling Jobs in SQL Server 2005

Multiple joins on the same table

questionary — Wed, 25 Nov 2009 09:48:49 GMT

Hi.

I have a question to advanced SQL programmers/users. I would be very grateful if you could explain me in simple words why we use multiple joins on the same table (for example multiple left outer joins) - what benefits it brings?

examples would be appreciated

best regards
q

help with db design...

jrosh — Wed, 25 Nov 2009 09:42:59 GMT

I am designing a database system to store salary information. It includes different tables (salary,personal info , ect)

I want to make it use for different companies. Also i want each set of data to be separated. (by company wise). {i.e. i dnt want all the employee names of every company in one table!!}
what would be the best database structure for that.??

i tried 1. one db for 1 company
That looks like invain.

please help me. I jst want an idea. thankx in advance

Oracle Service Start up

Blaine Tuisee — Tue, 24 Nov 2009 23:27:15 GMT

I currently run an installer app that will install a DB on a VM server. However this fails because the when oracle is called to begin the oracle services start up but the newly installed DB will not. It works on a physical machine but not on the virtual server. Any ideas on why this configuration will not work. I am working with Oracle 10 xe although it does work on the Standard edition.

query to get highest bid from data

gsc1ugs — Tue, 24 Nov 2009 10:25:43 GMT

Hi

I have this data

CustBid        idProduct        bidAmount        bidDate

1        272        165.00        2009-11-20 09:05:31.640

1        272        155.00        2009-11-20 09:05:25.480

4        272        95.00        2009-11-19 12:40:44.973

4        272        85.00        2009-11-19 12:40:40.377

1        272        85.00        2009-11-12 11:20:52.400

1        272        85.00        2009-11-12 11:20:52.400

4        272        75.00        2009-11-12 11:11:02.080

1        272        65.00        2009-11-12 11:20:20.170

1        272        45.00        2009-11-12 11:08:02.407

1        272        25.00        2009-11-12 11:05:06.663

and I want to be able to list the second highest bid that is not the same user so what i would like to display is 95 because bidder 1 has two higher so i dont want those proxy bids visible, what query could i use? have this so far

Select bidhistory.idCustomerBid as CustBid, bidhistory.idProduct, bidhistory.bidAmount, bidhistory.bidDate From bidhistory where (bidhistory.idProduct = 272) AND (idCustomerBid <> 2) order by bidAmount desc

Recommend SQL Editor

GL.Za — Tue, 24 Nov 2009 08:17:46 GMT

Hi everyone.

Can someone please recommend a SQL editor (other than SQL Developer) that will allow me to test out my SQL statements & queries outside of the DB environment.

I will predominantly be working in a windows environment, but may move to a linux environment at times. Will be most beneficial if the editor is able to connect to both Oracle and SQLServer DB's.

Also I would prefer the editor to be "free" but that is isnt so important.

Any help would much appreciated.
Thanks in advance
Jody

How to use unused space / white space in SQL server 2000

xirosen — Tue, 24 Nov 2009 04:24:18 GMT

Hi,,, we have a database grown too fast... from 19GB last march 09 into 52GB this Nov 09... I search through internet on what happen why do database grow fast and i find nothing,, i found out on how to "sp_spaceused" query and the result says:

database_name database_size unallocated space
MPSDB 52808.63 MB 4248.71 MB

reserved data index_size unused
49589288 KB 6859920 KB 2001880 KB 40727488 KB

My question is: is there's a way on how to use the unused bytes/allocation or can we remove those whitespaces to gain more space in our HD drive?

Help pls... i'm begging you all geniuses to pls help me.. tnx

Help with an Inventory Update trigger

TJGreene — Tue, 24 Nov 2009 01:07:54 GMT

I'm currently studying SQL and have created two tables (Orders and Inventory). I have been trying to create a trigger on the "OrderDate" column of the Orders table to update the Cur_Stock value (to subtract the Quantity ordered from the Cur_Stock) on the Inventory table whenever a new Order is placed. I've tried searching the internet but haven't had any success and I need some help with it.

HERE IS MY CODE:

CREATE TRIGGER [UpdateInventory]

ON [dbo].[Orders]

   FOR INSERT

AS

DECLARE @OrderDate smalldatetime

                @Quantity INT



        

SELECT @OrderDate = OrderDate, @Quantity=Quantity FROM Orders



BEGIN

UPDATE Inventory

SET Cur_Stock = Cur_Stock - @Quantity

WHERE @OrderDate = GetDate()

END

But obviously it isn't working. Can someone help me understand what I'm missing and WHY the above isn't working?

Thanks.

Pivot Table with dynamic Columns

kardsen — Mon, 23 Nov 2009 21:53:54 GMT

I am trying to write a query in my .net app and I'm having trouble pivoting the table since the columns are generated dynamically (based on a month range selected by the user)

SELECT SUM(HEALTH_MTTR) AS MTTR, SUM(HEALTH_OTR) AS OTR, SUM(HEALTH_REPEAT) AS REPEAT, SUM(HEALTH_CHRONIC) AS CHRONIC, SUM(HEALTH_TOTAL) AS TOTAL, (CAST(CAST(YEAR([DATE_RESOLVED_FOR_CLOSURE]) AS VARCHAR(4)) + '-' + Right('00' + CAST(MONTH([DATE_RESOLVED_FOR_CLOSURE]) AS VARCHAR(2)), 2) AS VARCHAR(7))) As YearMonth

FROM TRT_remedy_tickets 

WHERE COMPID = @COMPID AND (CAST(CAST(YEAR([DATE_RESOLVED_FOR_CLOSURE]) AS VARCHAR(4)) + '-' + Right('00' + CAST(MONTH([DATE_RESOLVED_FOR_CLOSURE]) AS VARCHAR(2)), 2) AS VARCHAR(7))) BETWEEN @START AND @END

Group By (CAST(CAST(YEAR([DATE_RESOLVED_FOR_CLOSURE]) AS VARCHAR(4)) + '-' + Right('00' + CAST(MONTH([DATE_RESOLVED_FOR_CLOSURE]) AS VARCHAR(2)), 2) AS VARCHAR(7)))

Generates a table like so:
MTTR OTR REPEAT CHRONIC TOTAL YearMonth
x x x x x 2009-06
x x x x x 2009-07
x x x x x 2009-08

And I need the table to be displayed like so
TYPE 2009-06 2009-07 2009-08 2009-09
MTTR x x x x
OTR x x x x
REP x x x x
CHR x x x x
TOT x x x x

Can we insert data in multiple table with single query in mysql

aruti — Mon, 23 Nov 2009 18:07:24 GMT

Please tell me can we insert data in multiple table with single query in mysql.

For example i have two table with name `table1` and `table2` and fields in `table1` are 'id' auto incremented and primary key, second field is 'name' data type varchar of 25 and another table `table2` have fields 'id' auto incremented and 'address' data type varchar 55.

I want to know is it possible to add the data in the fields of `table1` and `table2` with single insert query

getting missing operator error

bandibas — Mon, 23 Nov 2009 16:31:34 GMT

private void SubmitActionPerformed(java.awt.event.ActionEvent evt) {                                       

        try

        {

        Statement s = con.createStatement();

        Statement s1 = con.createStatement();

        Statement s2 = con.createStatement();

        Statement s3 = con.createStatement();

                

        ResultSet rs = s.executeQuery("select MAX(Guest_ID) from Guests");

        rs.next();

       int maxGuestID = rs.getInt(1) + 1;

       //s1.execute("insert into Guests values(" + maxGuestID + ",'" + txtUserName.getText() + "',' " + txtUserAddress.getText() + "','"+ txtUserPhone.getText() + "','"+ txtUserEmail.getText() + "','" + cmbCreditCardType.getSelectedItem() + "','"+ txtCreditCardNumber.getText() + "')");



        // insert data into reservation table

        ResultSet rs1 = s2.executeQuery("select MAX(Reservation_ID) from Reservation");

       rs1.next();

       int maxResID = rs1.getInt(1) + 1;

  //i'm getting error for date     

       s3.execute("insert into Reservation values(" + maxResID + "," + maxGuestID +",'"+ChkPrepaid.getSelectedObjects()+",'"+txtCheckInDate.getText()+"','"+txtCheckOutDate.getText()+ "'");

       

       

        }

        catch(Exception e)

        {

                    System.out.println("Error: " + e);

        }

HeLp plZ Save a daily query result as Csv Into New File

Likethatjazz — Mon, 23 Nov 2009 14:47:04 GMT

Hi all,

i use mssql 2005

I have a doubt, how to create a schedule for a query to run every day,the result should be saved every time the query runs, into a new file

For the moment I use SQL Server Agent to do this daily,
with a jobtask and my query inserted. The output has no extension
he doesn’t seem to make a new file every time, just replaces it.

Also the outputtfile should be automatically saved/exported as an Csv file.If thats possible...
These are my first steps with mssql server.
Im loving it, but now Im stuck since a few days.

Greetz Kristof

Reverse engineering! (MySQL and PHP)

bigjoke — Mon, 23 Nov 2009 11:27:39 GMT

Hi everyone,

I am tasked to alter the front-end of the database and have been given the whole wad of PHP files and also an .SQL file.

My question is, Why i cant see any changes to the database front-end when i change the .sql file. (I tried creating a new column in one table, lets call it abc123, and column name is equipment_name).

Its pretty basic question but has got me totally stumped. Also, would appreciate if someone could guide me on how to proceed to change the front-end. what files will i actually need to update to see the changes ive made to any table/database .

looking for quick answer.

Kind regards,

Driver issue

palavi — Mon, 23 Nov 2009 11:08:40 GMT

Hi All,

I am able to connect to the database from backend that is toad.But from the java application i can't . The error is from the line

Connection conn =



      DriverManager.getConnection



      ("jdbc:oracle:thin:@vrs1.india.mitey.com:1591:dapps");

I am getting the following error:

Exception in thread "main" java.lang.ArrayIndexOutOfBoundsException: 7

        at oracle.security.o3logon.C1.r(C1)

        at oracle.security.o3logon.C1.l(C1)

        at oracle.security.o3logon.C0.e(C0)

        at oracle.security.o3logon.O3LoginClientHelper.getEPasswd(O3LoginClientHelper)

        at oracle.jdbc.ttc7.O3log.(O3log.java:287)

        at oracle.jdbc.ttc7.TTC7Protocol.logon(TTC7Protocol.java:227)

        at oracle.jdbc.driver.OracleConnection.(OracleConnection.java:198)

        at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:251)

        at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:224)

        at java.sql.DriverManager.getConnection(DriverManager.java:525)

        at java.sql.DriverManager.getConnection(DriverManager.java:171)

        at parts.JdbcTest.main(JdbcTest.java:43)

Pl. kindly help if any ideas pl.kindly suggest.

Help with a Following Query

vuyiswamb — Mon, 23 Nov 2009 10:30:01 GMT

Good Day All

i have the Following that table

ID  | ACTV |VENU |STUD | TRIES

=====================================

1        1   4         162             0

2        4   5         104             0

3        8   5         138             0

4        15  2         68             0

5        15  4         291             0

6        21  4         171             0

7        22  5         101             0

8        27  4         11             0

9        28  5         6             0

10        31  4         8             0

11        32  6         6             0 

12        33  4         308             0

13        35  6         68             0

now i have the Following Query that Tries to find the ID's of the records that appear twice in the "VENU" Field.

SELECT id 

FROM [dbo].SOL_ACTV_VENU

group by  id 

having count(venu) > 1

order by sum(stud)

and it seems that it give me nothing while in the table i see there are records like that

Thanks

SQL tables and relation modelling

ratatu — Mon, 23 Nov 2009 10:19:37 GMT

what is the differances with SQL tables and relation modelling?

Any idea on what happen to our database.

xirosen — Mon, 23 Nov 2009 05:18:14 GMT

Hi,, i am a newbie in SQL server.. we have a database in our office.. I notice that since 2004 - 2008 our database growth was about 19GB, but since jan. 2009 to present our database grows from 19GB to 52GB... is there's something wrong happening in our database's configuration?

Can anyone pls share an idea..

Thanks..

Sorry for my english..

Changing numbering

studioceasar — Sun, 22 Nov 2009 18:18:46 GMT

Hi all,
I have a column in my table that auto increments as a counter as new records are added. I would like to renumber the entire column and have it start at 6000.

Can anyone suggest an sql line that would allow me to acomplish this?

Thanks in advance for your help.
C-

SQL question

dh111 — Sat, 21 Nov 2009 19:15:18 GMT

Is this the right place to ask the following?

I have 2 tables in two different MS Access DB's. Access allows the ability of inserting data from DBA.table1 into DBB.table1, using the format [dba].[table1].[dbb].[table1]. Here's my problem.

Using a single SQL Statement I can't figure out the following. DBA.table1 has a record, with let's say ID 300. DBB.table1 has a 300 already, matter of fact the ID goes all the way to 550.

How do a write an insert statement that gets the full record from DBB.table1, but swaps puts in the 'next available' ID, which in the case, for DBB.table1, is 551?

ISO-8859-1 SQL error

CRAFTYARTS — Sat, 21 Nov 2009 18:49:22 GMT

when I try to create a new mail account in my mail broadcast control center I get this message:

SQL error: swd_act : ERROR: 1146 - Table 'craftyartsalesmailcatcher.swd_account' doesn't existContent-Type: text/html; charset=ISO-8859-1 SQL error: INSERT INTO swd_account (`isact` , `name`) VALUES ('1' , 'swd_act') : ERROR: 1146 - Table 'craftyartsalesmailcatcher.swd_account' doesn't existStatus: 302 Moved Location: /cgi-bin/amlmlite4/responder.cgi?ses=cTb7C4Sps3MkZBHvZLY_It8ry&act=account

any help with this?
thanks

Inserting Multiple rows into a single table.

fawkman — Sat, 21 Nov 2009 16:27:22 GMT

Hey guys

I am Using Oracle APex and have created a some tables running SQL commands. I am now trying to INSERT multiple rows of data into one of the tables but am running into issues.

I firstly tried the following:

INSERT INTO stock_item_table (stock_item_no, item_desc, item_price)

VALUES(11,'item1',12);

VALUES(12,'item1',22);

VALUES(13,'item1',32);

VALUES(14,'item1',42);

but this didn't work. and I got the following error: ORA-00911: invalid character

After reviewing the following Oracle thread on DaniWeb http://www.daniweb.com/forums/thread212239.html I created this script.

INSERT INTO stock_item_table (stock_item_no, item_desc, item_price)

SELECT 11 AS stock_item_no, 'item1' AS item_desc, 12 AS item_price FROM dual

UNION SELECT 12 AS stock_item_no, 'item1' AS item_desc, 22 AS item_price FROM dual

UNION SELECT 13 AS stock_item_no, 'item1' AS item_desc, 32 AS item_price FROM dual

UNION SELECT 14 AS stock_item_no, 'item1' AS item_desc, 42 AS item_price FROM dual

UNION SELECT 15 AS stock_item_no, 'item1' AS item_desc, 52 AS item_price FROM dual

UNION SELECT 16 AS stock_item_no, 'item1' AS item_desc, 62 AS item_price FROM dual

UNION SELECT 17 AS stock_item_no, 'item1' AS item_desc, 72 AS item_price FROM dual

UNION SELECT 18 AS stock_item_no, 'item1' AS item_desc, 82 AS item_price FROM dual

UNION SELECT 19 AS stock_item_no, 'item1' AS item_desc, 92 AS item_price FROM dual

UNION SELECT 20 AS stock_item_no, 'item1' AS item_desc, 112 AS item_price FROM dual

UNION SELECT 30 AS stock_item_no, 'item3' AS item_desc, 12 AS item_price FROM dual

UNION SELECT 31 AS stock_item_no, 'item3' AS item_desc, 22 AS item_price FROM dual

UNION SELECT 32 AS stock_item_no, 'item3' AS item_desc, 32 AS item_price FROM dual

UNION SELECT 34 AS stock_item_no, 'item3' AS item_desc, 42 AS item_price FROM dual

UNION SELECT 35 AS stock_item_no, 'item3' AS item_desc, 52 AS item_price FROM dual

UNION SELECT 36 AS stock_item_no, 'item3' AS item_desc, 62 AS item_price FROM dual

UNION SELECT 37 AS stock_item_no, 'item3' AS item_desc, 72 AS item_price FROM dual

UNION SELECT 38 AS stock_item_no, 'item3' AS item_desc, 82 AS item_price FROM dual

UNION SELECT 39 AS stock_item_no, 'item3' AS item_desc, 92 AS item_price FROM dual

UNION SELECT 50 AS stock_item_no, 'item5' AS item_desc, 12 AS item_price FROM dual

UNION SELECT 51 AS stock_item_no, 'item5' AS item_desc, 12 AS item_price FROM dual

UNION SELECT 52 AS stock_item_no, 'item5' AS item_desc, 22 AS item_price FROM dual

UNION SELECT 53 AS stock_item_no, 'item5' AS item_desc, 32 AS item_price FROM dual

UNION SELECT 54 AS stock_item_no, 'item5' AS item_desc, 42 AS item_price FROM dual

UNION SELECT 55 AS stock_item_no, 'item5' AS item_desc, 52 AS item_price FROM dual

UNION SELECT 56 AS stock_item_no, 'item5' AS item_desc, 62 AS item_price FROM dual

UNION SELECT 57 AS stock_item_no, 'item5' AS item_desc, 72 AS item_price FROM dual

UNION SELECT 58 AS stock_item_no, 'item5' AS item_desc, 82 AS item_price FROM dual

UNION SELECT 59 AS stock_item_no, 'item5' AS item_desc, 92 AS item_price FROM dual

UNION SELECT 60 AS stock_item_no, 'item7' AS item_desc, 12 AS item_price FROM dual

UNION SELECT 61 AS stock_item_no, 'item7' AS item_desc, 12 AS item_price FROM dual

UNION SELECT 62 AS stock_item_no, 'item7' AS item_desc, 22 AS item_price FROM dual

UNION SELECT 63 AS stock_item_no, 'item7' AS item_desc, 32 AS item_price FROM dual

UNION SELECT 64 AS stock_item_no, 'item7' AS item_desc, 42 AS item_price FROM dual

UNION SELECT 65 AS stock_item_no, 'item7' AS item_desc, 52 AS item_price FROM dual

UNION SELECT 66 AS stock_item_no, 'item7' AS item_desc, 62 AS item_price FROM dual

UNION SELECT 67 AS stock_item_no, 'item7' AS item_desc, 72 AS item_price FROM dual

UNION SELECT 68 AS stock_item_no, 'item7' AS item_desc, 82 AS item_price FROM dual

UNION SELECT 69 AS stock_item_no, 'item7' AS item_desc, 92 AS item_price FROM dual;

I get the following error now: The requested URL /apex/wwv_flow.show was not found on this server

I am not sure what FROM dual is referencing, but should this be referencing the table I am inserting into? which in this case is stock_item_table? I do not have a table called dual. If anyone can help me out and explain what I have done wrong and what I need to change for this script to run I would be very grateful. Thanks for any ones time and help.

Kind regards

Decrypt of Password

Pranesh_Ashrit — Fri, 20 Nov 2009 11:17:14 GMT

Dear Users,

I have used SHA1 encryption method to encrypt password and stored in login table as a blob field.

Now, to authenticate the password, i need to decrypt it. I am not able to decrypt.

Please help me to decrypt password

Inserting into temporary table by dynamic query

carobee — Fri, 20 Nov 2009 10:40:52 GMT

Hi,

I have created a temporary @table and while inserting ,i am using dynamic sql.But this is not getting executed and throws an error that
"EXECUTE cannot be used as a source when inserting into a table variable"
i am using SQLServer2005.
Dont know where i am going wrong

DECLARE @SqlQuery NVARCHAR(4000);

        SELECT @SqlQuery='SELECT TOP '+CAST(@no_of_rows as CHAR)+'tblEmployee.id   ,

                        tblProject.ID, 

                        0,

                        0                          

        FROM         tblBilling (NOLOCK) '

INSERT @table 

EXEC @SqlQuery

MySQl Stored Procedure passing Parameters with parameter name and values

sonikadugar — Fri, 20 Nov 2009 10:31:31 GMT

IN MySQl Stored Procedure how to pass Parameters with parameter name and values i.e.

DELIMITER //

  CREATE PROCEDURE GetOffice

(countryName VARCHAR(255), countryId int(11))

     BEGIN

                 SELECT city, phone 

                 FROM offices

                 WHERE country = countryName AND 

                country_id = countryId;

     END //

  DELIMITER ;





CALL GetOffice("India",1);

This works fine but i want it the way --------
CALL GetOffice(countryName= "India",countryId=1);

Is there any way to pass parameters to stored procedure along parameter names in MySql.

Help in a loop query

blessanm — Fri, 20 Nov 2009 05:50:55 GMT

I have database with a table called orders. The structure is below

Index, OrderIndex, OrderNo
111, 1
112 , 1
113 , 1
114 , 2
115 , 3
116 , 3

I want a query that will loop thorugh the database and make the result

Index, OrderIndex, OrderNo
111, 1, 1
112, 1, 2
113, 1, 3
114, 2, 1
115, 3, 1
116, 3, 2

Im trying to change the OrderNo based on the OrderIndex.

Is there a way to do this purely using sql? If possible please help.

SQL query noob...

J3vr0N — Thu, 19 Nov 2009 20:23:03 GMT

Hi, I have a question regarding a SQL query. I am a complete noob, so please do not make fun of me.

Here is a schema that I created:

JOURNALS(j_num, j_name, j_subject_area, chief_editor_r_ssn)

ISSUES(j_num, i_num, i_date, i_num_pages)

RESEARCHERS(r_ssn, r_name, r_address, r_phone, r_institution)

ARTICLES(art_num, art_title, art_area_topic, art_abstract, j_num_submitted,date_submitted, j_num_published, i_num_published)

AREA_EDITS(j_num, r_sssn)

WRITES(r_ssn, art_num)

REVIEWS(r_ssn, art_num)

RESEARCH_SPECIALTIES(r_spec_name)

RRS(r_ssn, r_spec_name)

It's pretty simple. My question is regarding the linking of the primary keys. Is it necessary to link the primary keys if I were doing something like: The number of journals for which researcher ‘Albert Einstein’ is the chief editor?

The SQL query I came up with is:

SELECT count (*), j.j_num

FROM journals as J, Researchers as R, Area_edits as AE

WHERE J.chief_editor_r_ssn=R.r_ssn

AND R.r_name="Albert Einstein"

AND R.r_ssn=AE.r_ssn

AND J.j_num=AE.j_num;

Is it necessary to include the last 2 steps, or are the unneeded?

please solve this query

jck6288 — Thu, 19 Nov 2009 15:39:43 GMT

create a query that will display total no of employee and no of employee that hired in 1995,96,97 from employee table..

my employee table have field like
emp_id name hire_date.

Mysql Query results with Hyperlink and Font example

StePu — Thu, 19 Nov 2009 15:22:40 GMT

Hey,

This is my first post so go easy :)

I’m in the middle of designing a website users can download files from. I’ve searched the web and found the perfect example of what I’m trying to achieve which is something clear and simple (http://www.getfreefonts.info/free_fonts.a.html)

From the category’s at the top A-Z how, can I return the results with a hyperlink and example of the font? I’m new to web designing (only done 1 before) but I know I need mysql and PhP.

Regards
Steve

Partitioning

oyeubugme26 — Thu, 19 Nov 2009 06:17:08 GMT

Below is the table and the data related to it .How to do we go ahead and create partitioning for this table .Below table had like 50 million of records.

CREATE TABLE l_play ( 

Pl_id int(11) not null auto increment 

E_Id` int(11) NOT NULL, 

F_Id` int(11) DEFAULT NULL, 

P_Id` int(11) DEFAULT NULL, 

P_T` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, 

PRIMARY KEY (`pl_id`), 

KEY FK_log_playlog_processor` (`Proc_Id`), 

KEY FK_log_playlog_file` (`Fi_Id`), 

CONSTRAINT FK_log_playlog` FOREIGN KEY (`Fi_Id`) REFERENCESlog_file` (`Fi_Id`), 

CONSTRAINT FK_log_playlog_prc` FOREIGN KEY (`Proc_Id`) REFERENCESlog_processor` (`Proc_Id`), 



) ENGINE=InnoDB DEFAULT CHARSET=latin1

Need to partiotion by date .. we get around each day around 1 lakhs of records .. so need to partition for each week or each month .
sample data :

102649, 31, 35,, 16, 2008-05-20 05:49:00.0
102650,1, 35, ,7, 2008-05-20 05:50:00.0
102651,2, 35,, 8, 2008-05-20 05:50:00.0
102652,1, 35,, 7, 2008-05-20 05:52:00.0
102653,5, 35,, 9, 2008-05-20 05:53:00.0
102654,1, 35,, 7, 2008-05-20 05:54:00.0
102655,6, 35,, 10, 2008-05-20 05:55:00.0

What is the best way to store tags in mysql?

virtualmisc — Wed, 18 Nov 2009 22:30:01 GMT

Hi
What is the best way to store tags in mysql database?
Please help me with this.
Thanks

count non empty xml nodes

londonstan — Wed, 18 Nov 2009 21:54:11 GMT

If i have some xml in the form



hello



     hiya

     hey





hello again

how can I

a) count the nodes? i.e. a, b, bi, bii, c, d so 6
b) count the nodes that are non empty a, bi, bii, d so 4

?

i have tried

xmldata.query('count(/root/*)') ))

but that only counts the top level nodes and I have no idea where to start with the non empty nodes

any help will be very much appreciated

Migrate data from Mysql to Mssql

asmikwen — Wed, 18 Nov 2009 16:23:46 GMT

Hi,

I am trying to transfer some data from a Mysql database onto a Microsoft SQL database. I would need your help on how to operate this migration as I am new to MSSQL. I have been looking on Google but there are not a lot of pages on that. Can someone help me?

Thanks.

2 update for 2 table

zodehala — Tue, 17 Nov 2009 17:43:47 GMT

this is post table
http://www.divran.com/script/upload/images/post.jpg

this is thread table
http://www.divran.com/script/upload/images/thread.jpg

lie you see

firstpostid in thread table = postid in post table and threadid's

i wanna update title column in thread table as title in post table
but how ?

i create following query for trying but i t does not run

UPDATE         thread

INNER         JOIN post ON thread.threadid=post.threadid

SET         thread.title=REPLACE(post.title)

WHERE         post.postid=thread.firstpostid

altering column order

studioceasar — Tue, 17 Nov 2009 15:29:04 GMT

Hello all,
Is there an easy way to edit the order of my colums in a table?
Presently, my colums are: cust_num, name, email, location, bday_day, bday_month, bday_year, state

I would like to list the "location" column after "state".

Can anyone offer a simple suggestion.

Thanks in advance.
C-

Parent and Child nodes from a table (navigation category table)

shibbard — Tue, 17 Nov 2009 10:26:24 GMT

Hi all,

I have a single table with both parent and child nodes, and each has an order number in it.

I am trying to write a single query to output them in order, its for a navigation list with categories and sub-categories.

I could manage it in code rather than in the SQL query but it would involve calling a query from within a query loop - which I want to avoid.

Table:

DBID | Title | ParentID | OrderNum

 1      aaa       0          1

 2      bbb       0          2

 3      ccc       1          1

 4      ddd       1          2

 5      eee       2          1

and I want to get a result set like:

DBID | Title | ParentID | OrderNum

 1      aaa       0          1      <<< main 

 3      ccc       1          1      <<< child

 4      ddd       1          2      <<< 2nd child

 2      bbb       0          1      <<< main 

 5      eee       2          1      <<< child

I have been looking at using a recursive SQL select or Common Table Expressions (CTE) but have not been able to figure it out yet.

Can anyone help point me in the right direction?

(Using SQL Server 2005 / ASP.Net C#)

Auto_increment

mr_scooby — Tue, 17 Nov 2009 04:25:30 GMT

I have a table that holds a users id and a cd number, what I would like is to be able to only increment the cd number based the users id not just incrementing it every time a new cd is created

table

CREATE TABLE IF NOT EXISTS `cdcreation` (

  `user_Id` int(3) NOT NULL,

  `cd_Number` int(2) NOT NULL,

  PRIMARY KEY (`user_Id`,`cd_Number`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

user id's start at 100, so if an id is present but no cd user 100 will get cd 1, if user 101 has no cd they get cd 1 as well, when user 100 makes next cd they get cd 2 and when user 102 gets 1st cd they get cd 1, so it increments based on user number and cd number.

Both cd number and user id will form the primary key, I would also like to be able to max the number of cd's able to be created to 5(this is not critical but a preference) I use AUTO_INCREMENT in other parts of my db but not sure how to implement it this way based on a user id.

any help much appreciated

Setting up veiws

ireverent — Tue, 17 Nov 2009 00:39:20 GMT

I am a Student working on a project useing mysql. I am trying to set up a view and keep getting an error that there is duplicate columns. Is there anyway other then specifiying each table.culumn to stop the view from trying to show both of the columns. If it helps the two columns are the primary key of one table and the foreign key of another.

Update 1 table without interfering the other

neosonic — Mon, 16 Nov 2009 18:16:40 GMT

Hi Daniweb guys,

This is my problem:
My .mdb (microsoft access 2003 file) is containing pricing table and client table.
(I used visual basic 6 to create an application)

The user can install my application in their own pc and record their client into a provided client table.

But, the company might change the pricing table every now and then. So the company needs to send (via email) the "update" for the pricing table every now and then.

So I want to update the pricing table without interfering the client table, will it be possible?

Thanks

I really need help linking tables MYSQL

josh06 — Mon, 16 Nov 2009 17:57:02 GMT

Hello everyone.

Basically, I am making a small site for my friends where we can create users and edit profiles and comment eachother.
Like a scaled down social network site. The problem is, I really can't get my head around the whole idea of relational databases.

What I have is a table for the users - which stores their username, password etc.
I then want this to link into my profile table, which stores their pictures and page-style information etc.
This could then link into other tables for things like comments or statuses etc.

I am using MySQL and I thought I could link e.g. the user table to the profile table by having the same id. For example, the user table has a user_id field (primary key) and a profile_id which links into the profile_id (primary key) on the profile table.
But I just don't get how to implement this.
It's really hard to explain. I want it, so that when a user registers - not only does the user_id auto increment, but so does the profile_id in the profiles table. And the pictures information and other information from the profile table can be used by the user table to define who the users are etc.

Could anyone please lend me a helping hand with this. I will try and explain more clearly if you would like.

Thank you a lot.

Josh

Limit values of an element

Lioshenka — Mon, 16 Nov 2009 17:40:56 GMT

Stupid question, really...

Say, if I have a Department tuple with "Faculty" field- how can I declare it on the design stage so it only can take the values of "Science", "Arts" or "Psychology"?

Department {
,
,
,
}

I am sure the way I declared it isn't correct. Also, can someone give me an example of the SQL code to do similar kind of thing?

I vaguely remember that in MS Acess you can create a drop down menu, so I guess it is posible, but I never knew what goes on under the GUI.

Many thanks!

count query

lifeworks — Mon, 16 Nov 2009 14:26:46 GMT

Hi

Been trying to write a query... I have a table of documents, and a table which registers everytime someone downloads a copy of the document. I want to create a report, in one query, which pulls out each document and counts the views... I thought it woudnt be too tough but have come unstuck...

$sql = "SELECT d.title, d.mktime, COUNT(r.id) FROM documents AS d LEFT JOIN clickreg AS r ON r.docid = d.id"

help please!?!

thanks

database schema for event calendar

venkat0904 — Mon, 16 Nov 2009 13:32:06 GMT

Hi all,

1) Users can belong to a specific group wherein when the group moderator publishes an event, its visible to all the members of group.

2) A normal user can publish event in his own calendar, to make that event visible to all users in group, the group moderator needs to approve it.

3) While adding an event, a user can select from a list of available resources which gets booked for event's duration and no one else can publish an event using those resources at the same time.

4) Also when a moderator adds a member to his group, the member needs to approve whether he agrees to be in that specific group. Only after he agrees, he can view that group's events.

5) A user can belong to more than one group.

if anyone has any suggestions... u r most welcome !!!
m a php developer and have absolutely no experience in DB design..
help me out guys..

My Insert statement needs a trim

kegathor — Mon, 16 Nov 2009 09:57:51 GMT

Hi,

I have an insert statement that i need to refine...basically I need to trim the first couple of letters of whats trapped inthe field.
so e.g.

Z:\aaa\1.jpg

needs to become

aaa\1.jpg

Im tried this but its not working

sImagelink = mid(request.form("Imagelink"),4,len(request.form("Imagelink")))

any ideas?

Netbeans and oracle

ceyesuma — Mon, 16 Nov 2009 06:19:53 GMT

The name of this question is oracle project
Hello and Thank you in advance for any assistance.

System info:

I presently use Netbeans6.7,MySQL,glassfish to work with learning JSF and java apps etc.

The Purpose of this post is:

I recently was presented with a tutorial to learn JSF and databases. It uses Oracle stuff.
(Ex)
Creating the TopLink Project The following instructions describe how to create a TopLink project using the Mapping Workbench.
Step 1: Launch OracleAS TopLink Mapping Workbench. Then, select File and New Project... from the main menu. In the Create New Project dialog, provide the name of an existing database (e.g. orcl) and click

The functionality of this code is:

My question is:

Is there any one familiar with this “OraclAS TopLink” program ? Can I just add it to what Im using now (listed above) ? It seems as if this program could use my MySQL databases and my programs written with Netbeans using glassfish and it will allow me to work with oracle toplink to make the database work with the class files.

Is this even close?

The errors related to this code are:

Code description:

Thanks again.
-ceyesumma

Note:
………………………………………………………………………………………………

Code description

how to create a tablespace that consist a fix number of extents?

flaskvacuum — Sun, 15 Nov 2009 16:46:11 GMT

i wanted to create a locally managed tablespace with uniform allocation of extents. And also want my tablespace to consist only let say 5 extents. It will use only one data file.

here is what i know:



CREATE TABLESPACE TABLE1

EXTENT MANAGEMENT LOCAL

UNIFORM SIZE 64K

DATAFILE 'C:\ORACLE\ORADATA\MYDB\TABLE1.DBF'

SIZE 5M

AUTOEXTEND AUTO;

I tried maxextents but error. I seriously have no idea whether is it possible to have a fix number of extents?

Getting Error While Trying to Use Count Function in Subquery in FROM Clause

Chad Gary — Sat, 14 Nov 2009 19:36:39 GMT

The below mysql query yeilds the following result:

SELECT COUNT(ProgramType) AS Counter

FROm credential_state

GROUP BY ProgramType;

Results:
Counter
4
7
7

I would like return the max from the above (7). The following query is giving my an error that says: Every derived table must have its own alias. Not sure what I'm doing wrong.

SELECT MAX(Counter) AS MAX FROM(SELECT COUNT(ProgramType) AS Counter

FROm credential_state

GROUP BY ProgramType);

Please HELP!


Name:
Title:
Address:
Comments:

DaniWeb IT Discussion Community - 16,126,127,128,129,142

Retrun a result of zero if no query results

help with sql join

Getting time out error while retrieving large data from MySQL.

(rsErrorOpeningConnection) Could not obtain information about Windows NT.

How to create a flat file in Oracle

ERD for tuition school

How can I connect my database on my localhost site driven by cakephp

Getting Field name from a select statement

mysql_num_rows(): supplied argument is not a valid MySQL result resource Problem

Hotel Room Reservation System

e r diagram help for either time table generation r info retrieval system

Database attaches as read-only, writes up permissions too

SQL Error Maessage when executing INSERT

PL/SQL

how to updete field for a set of records from one record in the same table?

insert pictures

Adding an Identity Later T-SQL

choice of join?!

Why this doesn't work?

Insert New Record

New Job Added - View it HERE

Importing .sql file into mysql - linux

~~ sql Examples ~~

MSAcs> How do I UPDATE a table using the data from MULTIPLE TABLES?

database suggestions

mysql and C++

Catastrophic failure - Number: -2147418113

Indexes?

SQL Function

ER Help Pls

searching problem in SQL server 2005

MS Access (1 to Many) Table Definition

Change from a Mysql database

Search for numeric values from a varchar field in SQL server

ER Diagram need help

Creating Fact and Dimension Tables

Java database

Enabling Network Connections?

Database Table designs

Need Help with EER Diagram and Tables

Need Help with EER Diagram

Querying for next and previous record info

can’t load_file database

Help with query

Hospital administration database

Database Archiving

Count on chars to match on another column

my clock to end postings does'nt work

Database Programming?

Store a photohraph in mysql

changed limits max_open_files warning in server

there is already an object named #instmsdb

Using

PHP and SQL to collate and print data (pdf format)

Vacation days off

increase maximum number of result sets

Scheduling Jobs in SQL Server 2005

Multiple joins on the same table

help with db design...

Oracle Service Start up

query to get highest bid from data

Recommend SQL Editor

How to use unused space / white space in SQL server 2000

Help with an Inventory Update trigger

Pivot Table with dynamic Columns

Can we insert data in multiple table with single query in mysql

getting missing operator error

HeLp plZ Save a daily query result as Csv Into New File

Reverse engineering! (MySQL and PHP)

Driver issue

Help with a Following Query

SQL tables and relation modelling

Any idea on what happen to our database.

Changing numbering

SQL question

ISO-8859-1 SQL error

Inserting Multiple rows into a single table.

Decrypt of Password

Inserting into temporary table by dynamic query

sql Examples