Date: 10/13/06 (C Sharp)    Keywords: database, sql

Yes, I'm beating my same dead horse, of course. Now, I'm really confused. But at least my confusion is limited to a single control this time. C# 2005 standard, Windows XP Pro, tied to a SQL Server 2000 database.

I have a control on a winform called cboName. Is is bound to a bindingsource called bsHosp, which goes back to a table called Hospitals. The bindingsource has a sort on it by name ascending, so everything in this box is in alphabetical order. Where I'm running into severe confusion is in the SelectedIndexChanged event (which has been the cause of all my woes over the past two weeks). The bindings on the combobox:
SelectedItem: bsHosp.Name
SelectedValue: bsHosp.ProvNo
Tag: (none)
Text: bsHosp.Name

(ProvNo and Prov_ID

In order to test the screwy databinding (check a few messages back in this community for a description), I put in a messagebox to check that the filter and sort on the other bindingsource were actually being changed. Here's the code for the SIC event:

private void cboName_SelectedIndexChanged(object sender, EventArgs e)
        {
            try
            {
                bsRate.Filter = "prov_id = " + txtProvNo.Text;
                bsRate.Sort = "mexp desc";
                bsRate.ResetBindings(false);
                MessageBox.Show("Filter = " + bsRate.Filter.ToString() + "      Sort = " + bsRate.Sort.ToString());
            }
            catch (Exception ex)
            {
            }
            finally
            {
            }
        }

Source: http://community.livejournal.com/csharp/76871.html

Date: 10/19/06 (C Sharp)    Keywords: database, sql, web, microsoft

Yes, I'm back.

        private string ConnectionString;
        private DataViewManager dsView;
        private DataViewManager dsViewHospitals;
        private DataSet ds;

        public TestHospitalFormGrid()
        {
            InitializeComponent();

            ConnectionString = "data source=edison;uid=sa;password=nothing;database=hospratestest";
            SqlConnection cn = new SqlConnection(ConnectionString);

            //Create the DataSet
            ds = new DataSet("HospRates");

            //Fill the dataset with hospitals
            SqlDataAdapter da1 = new SqlDataAdapter("select * from hospitals", cn);
            da1.TableMappings.Add("Table", "Hospitals");
            da1.Fill(ds, "Hospitals");
            //Fill the dataset with rates
            SqlDataAdapter da2 = new SqlDataAdapter("select * from CombinedRateData", cn);
            da2.TableMappings.Add("Table", "Rates");
            da2.Fill(ds, "Rates");

            //tables father back will go here later

            //Establish relatinship between hospitals and rates
            DataRelation relHospRates;
            DataColumn MasterColumn;
            DataColumn DetailColumn;
            MasterColumn = ds.Tables["Hospitals"].Columns["ID"];
            DetailColumn = ds.Tables["Rates"].Columns["prov_id"];
            relHospRates = new DataRelation("HospRatesRelation", MasterColumn, DetailColumn);
            ds.Relations.Add(relHospRates);

            dsView = ds.DefaultViewManager;
            dsViewHospitals = ???;

            dgDetail.DataSource = dsView;
            dgDetail.DataMember = "Rates.HospRatesRelation";
            //dgDetail.DataSource = "Rates.HospRatesRelation";

            cboName.DataSource = dsView;
            cboName.DisplayMember = "Hospitals.Name";
            cboName.ValueMember = "Hospitals.ID";
        }
    }

Source: http://community.livejournal.com/csharp/77639.html

Date: 10/19/06 (C Sharp)    Keywords: database, sql

So, I'm posting here in hopes that someone has encountered something like this before and knows a way to fix it.

this is a larger issue, but the crux of it is simply this query (yes it calles a sql server stored proc):

spRPT_TKT_ThreeDayCountReport null,null,null,null,null,null,'9/16/2006','10/15/2006',null,null,null,null,null,null,null,null,null


When executed from query analyzer (paste in, hit f5) connected to the production database I get one set of results.
When executed as a dataset (command type: text) in Sql Reporting Services, I get a different set of results.

The row counts and MOST of the associated data are exactly the same, the problem lies in SOME of the individual items are 0 (not null, just 0), in all cases these are sum(isnull(-variable-),0) items in the Sproc.

I am at a loss for why the results to this query are different from one application to the other. (and they are 100% reproducable).

any ideas?

Source: http://community.livejournal.com/csharp/78075.html

Date: 10/23/06 (IT Professionals)    Keywords: database, sql, microsoft

x-posted all over

My division is looking at upgrading our SQL Servers from 2000 to 2005 within the next six months. The other day, my boss asked me if I could do some online research to try and find an "Upgrade Cost Estimate calculator" of some sort. From his business perspective, for any given number of factors such as # of database servers, database average size, # of objects, etc., could be punched into some kind of magical formula to output an estimated manhour cost. He figures that someone HAS to have done this sort of analysis already, and is hoping that I can find it.

Has anyone out there heard of or seen such a thing, whether it be an online estimator, a PowerPoint presentation, or even a speech from a Microsoft rep? Thanks in advance!

Source: http://community.livejournal.com/itprofessionals/45680.html

Date: 10/23/06 (SQL Server)    Keywords: database, sql, microsoft

x-posted all over

My division is looking at upgrading our SQL Servers from 2000 to 2005 within the next six months. The other day, my boss asked me if I could do some online research to try and find an "Upgrade Cost Estimate calculator" of some sort. From his business perspective, for any given number of factors such as # of database servers, database average size, # of objects, etc., could be punched into some kind of magical formula to output an estimated manhour cost. He figures that someone HAS to have done this sort of analysis already, and is hoping that I can find it.

Has anyone out there heard of or seen such a thing, whether it be an online estimator, a PowerPoint presentation, or even a speech from a Microsoft rep? Thanks in advance!

Source: http://community.livejournal.com/sqlserver/53179.html

Date: 10/23/06 (Java Web)    Keywords: mysql, database, sql

First of all I want to make it clear that having a MySQL database without a password set (on your root account) is a very very bad idea. However I wanted to set it up on my home machine which has XAMPP installed. And XAMPP by default creates a root account for MySQL without any [...]

Source: http://blog.taragana.com/index.php/archive/how-to-use-vanilla-forum-on-mysql-database-without-password-set/

Date: 10/24/06 (SQL Server)    Keywords: database, sql

Hi all, forgive me if these have already been asked a zillion times...

1. what is the SQL query for determining the primary key of a table? meaning, i know there is SOMEthing like this that I can do:

select primary_keys from information_schema where table_name = 'myTable'

...but I don't remember the right syntax. anyone?

2. i'm building my database on a destkop machine. later, i want to do an export that will INCLUDE a very complicated database diagram that i've drawn in Enterprise Manager. is that possible? is there a way to save out JUST the diagram in some format that can later be imported into antoher SQL server machine elsewhere?

thanks for your time.

Source: http://community.livejournal.com/sqlserver/53307.html

Date: 10/24/06 (MySQL Communtiy)    Keywords: mysql, database, sql

Hello. I am so glad I found this community. I am very new to MySQL & completely lost. I'm using it for a Database Fundamentals course that I'm taking. The instructor isn't teaching us the material...she's expecting us to learn from the textbooks. I'm finding this to be a subject that's hard to learn from books alone. An example of what I'm having a problem with:

DROP TABLE IF EXISTS `book`;
CREATE TABLE `book` (
`BOOK_CODE` char(4) NOT NULL default '',
`TITLE` char(40) default NULL,
`PUBLISHER_CODE` char(3) default NULL,
`TYPE` char(3) default NULL,
`PRICE` decimal(4,2) default NULL,
`PAPERBACK` char(1) default NULL,
PRIMARY KEY (`BOOK_CODE`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `henry`.`book`
--

/*!40000 ALTER TABLE `book` DISABLE KEYS */;
INSERT INTO `book` (`BOOK_CODE`,`TITLE`,`PUBLISHER_CODE`,`TYPE`,`PRICE`,`PAPERBACK`) VALUES
('0180','A Deepness in the Sky','TB','SFI','7.19','Y'),
('0189','Magic Terror','FA','HOR','7.99','Y'),
('0200','The Stranger','VB','FIC','8.00','Y'),
('0280','Rumpole for the Defence','PE','MYS','7.19','Y'),
('0378','Venice','SS','ART','24.50','N'),
('0389','Concepts of Database Management','CT','CMP','43.99','Y'),
('079X','Second Wind','PU','MYS','24.95','N'),
('0808','The Edge','JP','MYS','6.99','Y'),
('1351','Dreamcatcher: A Novel','SC','HOR','19.60','N'),
('1382','Treasure Chests','TA','ART','24.46','N'),
('138X','Beloved','PL','FIC','12.95','Y'),
('1456','Truman','SS','HIS','29.90','Y'),
('2226','Harry Potter and the Prisoner of Azkaban','ST','SFI','13.96','N'),
('2281','Van Gogh and Gauguin','WP','ART','21.00','N'),
('2766','Of Mice and Men','PE','FIC','6.95','Y'),
('2908','Electric Light','FS','POE','14.00','N'),
('3350','Group: Six People in Search of a Life','BP','PSY','10.40','Y'),
('3743','Nine Stories','LB','FIC','5.99','Y');
INSERT INTO `book` (`BOOK_CODE`,`TITLE`,`PUBLISHER_CODE`,`TYPE`,`PRICE`,`PAPERBACK`) VALUES
('3906','The Soul of a New Machine','BY','SCI','11.16','Y'),
('5163','Travels with Charley','PE','TRA','7.95','Y'),
('5790','Catch-22','SC','FIC','12.00','Y'),
('6128','Jazz','PL','FIC','12.95','Y'),
('6328','Band of Brothers','TO','HIS','9.60','Y'),
('669X','A Guide to SQL','CT','CMP','37.95','Y'),
('6908','Franny and Zooey','LB','FIC','5.99','Y'),
('7405','East of Eden','PE','FIC','12.95','Y'),
('7443','Harry Potter and the Goblet of Fire','ST','SFI','18.16','N'),
('7559','The Fall','VB','FIC','8.00','Y'),
('8092','Godel, Escher, Bach','BA','PHI','14.00','Y'),
('8720','When Rabbit Howls','JP','PSY','6.29','Y'),
('9611','Black House','RH','HOR','18.81','N'),
('9627','Song of Solomon','PL','FIC','14.00','Y'),
('9701','The Grapes of Wrath','PE','FIC','13.00','Y'),
('9882','Slay Ride','JP','MYS','6.99','Y'),
('9883','The Catcher in the Rye','LB','FIC','5.99','Y'),
('9931','To Kill a Mockingbird','HC','FIC','18.00','N');
/*!40000 ALTER TABLE `book` ENABLE KEYS */;

How do I put that in proper format in a database, so I can run & install it in a MySQL database? Or can I run it as is?
Or are there any really simple resources that you could suggest, that might also offer some assistance?

Thank you so much for the help!

Source: http://community.livejournal.com/mysql/105012.html

Date: 10/25/06 (Java Web)    Keywords: database

Revision number of a file is an important information. Two most common uses are in serialization and in making version specific database upgrades for an application. I am using it for the later. Here is a simple way how you can add revision number (Id, Date, Author and HeadURL) automatically to your source files. First you [...]

Source: http://blog.taragana.com/index.php/archive/how-to-add-revision-number-id-automatically-to-subversion-files-in-two-simple-steps/

Date: 10/30/06 (PHP Community)    Keywords: database

So, my problem is that my script seems to be running twice for no apparent reason. I'm not sure what the problem is in the slightest, so here's an over kill explanation about my script;

Firstly, the script is for a game I'm making - it's basically a map for user to move around on. Obviously I've not added any of the fun stuff to it yet because I want to get the basics of "walking" out of the way first. The map is a grid consisting of 100 squares (10x10), made up by images of rocks, grass, etc. The user needs to be able to move north, east, south and west, and their position is shown by a little avatar in the centre of the map (unless they get too close to the edge, in which case the map stops "scrolling" though the user can still walk up to the edge of the map. If you followed that, well done.

Secondly, what's in database `game_map`. `user_map` is where information regarding the user is kept. Whilst I'm testing scripts the test user_id is 9. "curr_x_co" is the current user's position of "x" and "curr_y_co" is the same, but for "y".

Thirdly, here's the script.

Okay so here's what happens when I run the script. Stats first:

Previous Location: x 4, y 11
Current Location: x 4, y 11

Previous Location: x 4, y 11
Current Location: x 5, y 11

Previous Location: x 6, y 11
Current Location: x 7, y 11

Previous Location: x 8, y 11
Current Location: x 9, y 11

Source: http://community.livejournal.com/php/506241.html

Date: 10/31/06 (Asp Dot Net)    Keywords: database, asp

I have a question. I have created a class (DBClass) to act as a handler for interactions with a database. Creating an instance of that class opens a connection to the database, and the object then has a number of methods for handing transactions with the database.

Initially, my thought was to include the class definition file (which also creates a single instance of the object, called DB) at the beginning of each document. Then, I thought, I'd be able to reference the DB object anywhere in the page to interact with the database.

So, this is (a simplified version of) what my main page looks like:

<%@ Register TagPrefix="inc" TagName="title" Src="title.ascx" %>

 
  
 
 
  
 

The dbclass.aspx file contains the code that defines the DBClass class and creates a single instance of that class called DB.

Now, the title.ascx file defines a User Control that prints the title of the page, by looking up the URL of the page in a database and retrieving the corresponding title. That look-up in the database is handled by the DB object:

<%@ Control Language="VB" ClassName="TitleControl" %>
   

<% 
    Response.Write( DB.GetNameFromUrl( Request.ServerVariables("URL") ) )
%>
   

But when I run the main page, it gives a compilation error then trying to compile the Title Control, because I reference the DB object without declaring it inside that file (title.ascx).

Any idea how I can get the user control to be "aware" of the main DB object I've defined in the calling page?

Thanks for any help or insight..

Source: http://community.livejournal.com/aspdotnet/78710.html

Date: 11/08/06 (Java Web)    Keywords: database

Yesterday I received an often asked question from a close friend of mine and someone who I very much respect. In his words: My new company has an existing system that I am rewriting. The system has a database that follows the philosophy of never really deleting a record - just set a flag marking it deleted. What [...]

Source: http://blog.taragana.com/index.php/archive/to-delete-a-database-record-or-mark-as-deleted-a-discussion/

Date: 11/14/06 (Web Development)    Keywords: database, web, shopping

Hello everyone, I have web design job that needs to be filled asap. The description follows below. The website deals with herbal products, reviews, shopping, etc. Please email if you are willing to complete the job, and be sure to include a bid (please note this is not a high budget project). Thank you! cgraydon@gmail.com

Web designer needed to construct website for herbal products. Sections to be included: reviews, informational articles, buyer beware and more. Must also have an e-commerce system for selling.

Dependant upon pricing, a user database may or may not be required at this time. If the budget does not allow for such database, ability to create, use and manage database must be left in design for later insertion.

Website is not expected to contain more than 20 pages.

Project must be ready by end of 2006.

Source: http://community.livejournal.com/webdev/370217.html

Date: 11/14/06 (WebDesign)    Keywords: database, web, shopping

Hello everyone, I have web design job that needs to be filled asap. The description follows below. The website deals with herbal products, reviews, shopping, etc. Please email if you are willing to complete the job, and be sure to include a bid (please note this is not a high budget project). Thank you! cgraydon@gmail.com

Web designer needed to construct website for herbal products. Sections to be included: reviews, informational articles, buyer beware and more. Must also have an e-commerce system for selling.

Dependant upon pricing, a user database may or may not be required at this time. If the budget does not allow for such database, ability to create, use and manage database must be left in design for later insertion.

Website is not expected to contain more than 20 pages.

Project must be ready by end of 2006.

Source: http://community.livejournal.com/webdesign/1187107.html

Date: 11/16/06 (PHP Community)    Keywords: php, programming, mysql, database, sql, web

So I wanted an opinion on some books. I consider myself very well... dumb, in PHP. I can write simple backends to manage website content, upload files, screw with databases... but while loops, for statements, classes... they scare me.

In an effort to expand my knowledge of PHP I recently purchased two books:

Web Database Applications with PHP and MySQL (2nd Edition) by O'Reilly
Object-Oriented PHP: Concepts, Techniques, and Code by Peter Lavin

And the only purpose of this post is to see if any of you have opinions on these books, or suggestions for what I could do to begin obtaining a more robust handle on PHP programming. Because honestly... I'd rather code PHP than design another club flyer.

Source: http://community.livejournal.com/php/510766.html

Date: 11/17/06 (Web Development)    Keywords: database, sql, security

Ok, so here's the situation: Migrating from one server to another, and from MS SQL 2000 to MS SQL 2005. The approach I found recommended is dettaching the database on SQL 2000, moving it to the new server, and attaching on SQL 2005. This process worked, but here's the problem:
The database owner on the original machine is someusername. This information is embedded in the database, and when it's attached on the new server, still remains. When I try to go to database properties/permissions and remove the user, it removes it, but when I close the window and then reopen it, the user is there yet again. When I try to create a new user with the same name through Security/Logins and give it rights to the new database, it says that that username is already associated with the database and that it can't do this.

So are there any solutions to this specific problem or another way of moving from MS SQL 2000 to MS SQL 2005?

Thanks!

Source: http://community.livejournal.com/webdev/370919.html

Date: 11/19/06 (PHP Community)    Keywords: php, mysql, database, sql

Hi. I'm not really completely sure as to why this is happening. Here's my error message:

Fatal error: Call to a member function Execute() on a non-object in /opt/lampp/htdocs/medievalbattles/current/v8/httpdocs/include/functions.php on line 16

Here's the functions.php line (the whole function, really). Line 16 is $result = $__db->Execute($sql);
----------
// Does this email exist already?
function checkemail($email)
{
    global $dbname;
    $sql = "SELECT * FROM $dbname.accounts WHERE email = '$email'";
    $result = $__db->Execute($sql);
    if ($result->RecordCount >= 1)
    {
        $uid = $result->fields["id"];
        return $uid;
    }
    else
        return false;
}
----------

At the top of functions.php, I am including my config file (include("config.php");)

The contents of config.php are as follows:
----------
#####################
## Database variables
#####################
$dbhost = "localhost";
$dbuser = "root";
$dbpass = "";
$dbname = "mb_game";

/*
* ADOdb Lite v1.30
* http://adodblite.sourceforge.net/index.php
*/
require_once("/opt/lampp/htdocs/medievalbattles/current/v8/httpdocs/adodb/adodb.inc.php");

$__db = ADONewConnection($dbtype);
$__db->debug = false;
$__db->Connect($dbhost, $dbuser, $dbpass);
----------

Any idea as to why I'm getting this error?

(PHP v5.1.4 - MySQL v5.0.21)

Source: http://community.livejournal.com/php/512496.html

Date: 11/22/06 (PHP Community)    Keywords: mysql, database, sql

ETA: Solved with the help of nickinuse.

Hi guys, I'm trying to make an email verification script.
1. User enters values to the contact form (done)
2. Contact form sends verification email to the entered user email (done)
3. User clicks on the link and verification process is complete (I'm stuck here)



// 1. open connection to MySQL (okay, done!)
$koneksi = mysql_connect($db_host, $db_user, $db_password) or die(mysql_error());
$db_select = mysql_select_db($db_name) or die(mysql_error());

// 2. query the database to see if the verification string match the ones in the database (this is okay, too!)
$query = "SELECT email_id FROM email_ver WHERE verify_string=$verify";
$result = mysql_query($query);
while ( $data = mysql_fetch_array($result) )
{ $drid = $data['email_id']; }
if ($drid!=$id)
{ $t="There are no such ID or request."; }
else {
// 3. query the database to update that email has been verified (this is where I'm stuck!)
$query = "UPDATE email_ver SET email_verify='y', verify_string='0' WHERE email_id=$id";
// specifically these next two lines!
$result = mysql_query($query) or die(mysql_error());
$num_rows = mysql_affected_rows($result);
// if the query work
if ($num_rows > 0) { echo "Yay! Your email is valid!"; }
}


I got this following error:
Warning: mysql_affected_rows(): supplied argument is not a valid MySQL-Link resource

Why is that happen? When the actual query is successfully done in the database (I've checked and re-checked). [Edit: It's because I'm feeding it with the wrong kind of resource. *LOL*]

Thanks!

Source: http://community.livejournal.com/php/513516.html

Date: 11/22/06 (SQL Server)    Keywords: programming, database, sql

I think I know the answer to this, but I want to see if anyone has a different one...

I have a database (well, I have a spec, I'm not creating it until I know the answer to this question) I'd like to create on a flash drive. Is this possible? It seems to me that one has to create all databases from a given SQL Server instance in the same directory...

(Basically, I'd like to be able to access the database from four SQL Server instances on two different networks and one non-networked computer-- because those are the locations I'll be programming the front-end app.)

Source: http://community.livejournal.com/sqlserver/53898.html

Date: 11/25/06 (WebDesign)    Keywords: php, html, database, web, hosting

I need some help with web work ... a few hours per week worth ... if you already know html &/or php, I need ya ...

Examples ...

:: Web site pages are designed, graphics/layout is done ... just need someone to make up the new pages; make tables + add text ...

:: A client's blog program has been added ... php ... I will provide graphics ... need you put the graphics in place, edit pages to size specifications and help set it up for the client ...

:: A client needs a store ... I'll install the program, I need you make it look 'pretty' ...

:: I moved my board ... php ... from one server to another ... some of the posts are missing, I didn't realize it for about a week, have a back-up copy before the move ... need you to go through the posts find out which ones are missing, then add the missing posts to the database ...

:: I need graphics ...

Et cetera! Et cetera! Et cetera!

I will pay via PayPal, postal money order, give you free hosting, &/or pay for a few on-line subscriptions/renewals ... depending on work completed and your preference ...

I have lots and lots that I need help with, let me know what you can do and point out a few examples ... please + thank ya :)

Source: http://community.livejournal.com/webdesign/1189002.html