Date: 02/02/06 (Asp Dot Net)    Keywords: browser, database, sql, web

Assuming you're not all sick of me yet, I have another question.
I have 2 web pages. On the main page there are links that are binded to a database. Clicking on those links will open up another window that has more details about that particular topic. On that detail page I want to add a button that will close that detail window, then have the main page WINDOW go to a page that only shows courses available on that topic. That information would be accessed via a SQL Query.

So for example (because I'm sure this is very confusing,) on the main page you click on a link to learn more about the Manager Training course. A window comes up showing all the information about the Manager training course. You then click on a button. That detail window closes, and the main page goes to another page that only shows all the Managers Training Courses. My main question is how I can tell the main page window to go to this other page and pass the information needed so that it can query the database and bind the correct information to it. I know this is very easy if everything is in the same browser window, but I don't know how you do it with multiple windows. Thanks.

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

Date: 02/03/06 (PHP Community)    Keywords: php, mysql, html, database, sql

I have the following login script when it logs in it just goes straight to back to the login page. Now I've worked out it's something to do with the else or if ( $num != 0) statement as when commented out it goes thru ish but it doesn't print the $msg variable which I have an echo statement calling on it in the html body..The session start/auth isn't being worked on atm hence why it's been commented out.



#set variables
$usr = $_POST['username'];
$pass = $_POST['password'];
$self = $_SERVER['PHP_SELF'];
/*#Start session and auth it
if (isset( $usr ) and isset( $pass ) )
 {
     session_start();
     $_SESSION['authorized'] = 'ok';
     $url = (isset($_GET['url'])) ? $_GET['url'] : 'index.php';
     header("Location: $url");
   }*/
#check form not empty
if ( (!$usr) or (!$pass) )
 {
  header ("Location:{$_SERVER['HTTP_REFERER']}");
  exit();
 }
#connect to sql db
$conn = @mysql_connect( "localhost", "xxx", "xxx" ) or die( "Could not connect to SQL" );
$rs = @mysql_select_db ( "xxx", $conn ) or die ( "Could not select database" );
#select db
$sql = 'select * from users where \'user_name\'=\'$username\' and \'password\'= password(\'$password\')';
#execute the query
$rs = mysql_query($sql, $conn) or die ( 'Could not execute query' );
#get no. of matching rows
$num = mysql_num_rows ( $rs );
#check for match
if ($num != 0 )
 {
  $msg = 'Welcome $usr - you are now logged in';
 }
else
 {
  header ("Location:{$_SERVER['HTTP_REFERER']}");
  exit ();
 }

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

Date: 02/03/06 (Asp Dot Net)    Keywords: php, mysql, database, asp, sql, web, google, apache

Hey guys,

This is not an asp.net technical question, but I thought maybe someone here could help me out.

I need to switch web hosts. The one I have now has terrible customer service and thinks that it is normal to take the web server down for several hours every day, and not bother to tell their customers that they do so. I found them through Google and I don't want to try that again.

I've tried looking for recommendations elsewhere, but all the ones I've found have been for Apache web servers. I need an IIS web server that has: ASP.NET/ADO.NET and PHP4/5 supported, MySQL or SQL Server databases, along with the standard mail accounts, web statistics, ftp access, etc. It's just for a couple personal sites, so I don't need a lot of bandwith or space, just need reliable servers with little downtime and good customer service.

Any recommendations?

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

Date: 02/05/06 (PHP Community)    Keywords: php, mysql, database, sql, apache

FIXED. Thanks to hipmaestro -- I downloaded PHP 4.3.11 and upgraded my installation, and it's fixed. :)

I've been working at this since last night -- and I'm quite clueless about what's happening. I was thinking that it could possibly be that my system has been working too long and there are weird memory leaks (yes, I have no more good ideas) so I thought I'd just go back in the morning... but now it's morning and the error is still there. The error is-- at some point of the script, a certain variable gets overwritten with the text of the next variable.

This is how the script is set up: there is a config file that's included all over the place -- in all the visible pages and in each function (I'm toying with the idea of using constants instead, but for now this is what I'm using). The config file has the database variables, and along the top I define the connection stuff:

$db_server = 'localhost';
$db_user = 'username';
$db_password = 'password';
$db_database = 'databasename';

• get_setting( $settingshortname );
• get_setting_title( $settingshortname );
• get_setting_desc( $settingshortname );
• update_setting( $settingshortname, $newvalue );
• ...

echo '$db_user is now: ' . $db_user . '

';
$db_server = 'localhost';
$db_user = 'username';
$db_password = 'password';
$db_database = 'databasename';
echo '$db_user is now: ' . $db_user . '

';

Notice: Undefined variable: db_user in D:\Site\devt\Enth3\enth3\config.php on line 11
$db_user is now:

$db_user is now: password

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

Date: 02/06/06 (MySQL Communtiy)    Keywords: php, mysql, sql, web

Howdy,

Suppose I want a way to easily backup a SQL table. (I use MySQL but that shouldn't matter.) I would like to be able to have a link on my website that, when I click on it, lets me download a TXT file with all of the data in tab separated values, so I can easily load it into excel.

Somebody suggested using select into outfile 'filename', but I must admit that the mySQL manual baffles me and I have a hard time getting any help from it. So, how would I use it in this regard?

Thanks much!

(crossposted to php community)

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

Date: 02/06/06 (PHP Community)    Keywords: mysql, sql, web

Howdy,

Suppose I want a way to easily backup a SQL table. (I use MySQL but that shouldn't matter.) I would like to be able to have a link on my website that, when I click on it, lets me download a TXT file with all of the data in tab separated values, so I can easily load it into excel.

Is this possible, and, if so, how do can I do it?

Thanks much!

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

Date: 02/06/06 (PHP Community)    Keywords: php, mysql, sql, web

Ok, I have the following function that until the other day worked fine.
It has now stopped and i have no idea why. The only think i know of
that has been done on my web server recently is MYSQL have been
upgraded.

function img_resize($path,$w,$h,$quality,$save){

$image_data=@getimagesize($path);

$image_type=$image_data[2];
$gd_ext=array('','jpg','gif');
if($image_type!=1&&$image_type!=2) return false;
if($save=='') header('Content-type: '.$image_data['mime']); else $save=eregi_replace('%ext',$gd_ext[$image_type],$save);

if($w!=0){
$rapporto=$image_data[0]/$w;
if($h!=0){
if($image_data[1]/$rapporto>$h) $rapporto=$image_data[1]/$h;
}
}elseif($h!=0){
$tmp_h=$image_data[1]/$h;
}else{
return false;
}

$thumb_w=$image_data[0]/$rapporto;
$thumb_h=$image_data[1]/$rapporto;

if($image_type==1) $img_src=@imagecreatefromgif($path);
elseif($image_type==2) $img_src=@imagecreatefromjpeg($path);

$img_thumb=@imagecreatetruecolor($thumb_w,$thumb_h);
$result=@imagecopyresampled($img_thumb,$img_src,
0,0,0,0,$thumb_w,$thumb_h,$image_data[0],$image_data[1]);
if(!$img_src||!$img_thumb||!$result) return false;

if($image_type==1) $result=@imagegif($img_thumb,$save);
elseif($image_type==2) $result=@imagejpeg($img_thumb,$save,$quality);

return $result;
}

Now
this code is meant to take an image (full path including filename as
$path) and make it the size set when called and then save it to the
name and path set as $save.

When it makes this file, it is a
copy, so nothing is done to the original. Now this function is part of
the admin section to my gallery which is there just to make and store
the thumbnails. I have no idea why this isn’t working, but I have tried
a few of the scripts in the php docs with no luck. Php is working, so
it isn’t that, so does anyone know how I could do this function in the
most compataible way possible? Bear in mind I’m still a bit of a n00b,
well with image manipulation at least.

Thanks for any help.

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

Date: 02/06/06 (Computer Geeks)    Keywords: php, technology, database, asp, sql, web

We currently have an application at my job that uses portlet technology (websphere as far as I know) in order to maintain an track an SQL database filled with articles pertaining to Marketing. It’s a lot of bells and whistles for something that can be easily coded and maintained using either PHP or ASP especially when the guy who is the admin of the application can’t even maintain it. Most of the upgrades and changes are done by another person and not the admin for the application; however, the admin is trying to justify the need for additional portlet technology. I have been asked to research the need and use of portals for our division due to budget cuts.

Currently, we are using MS SQL to develop and maintain databases and use ASP.NET in order to create and develop the webpages. We have a large audience, but the only about 5K of users depending on the application. The servers are running Windows 2000 as well. I would LOVE to have some resources that shows the pros and cons of using WebSphere, or if any of the members have any experience with WebSphere.

Source: http://community.livejournal.com/computergeeks/875901.html

Date: 02/06/06 (Web Development)    Keywords: php, technology, database, asp, sql, web

We currently have an application at my job that uses portlet technology (websphere as far as I know) in order to maintain an track an SQL database filled with articles pertaining to Marketing. It’s a lot of bells and whistles for something that can be easily coded and maintained using either PHP or ASP especially when the guy who is the admin of the application can’t even maintain it. Most of the upgrades and changes are done by another person and not the admin for the application; however, the admin is trying to justify the need for additional portlet technology. I have been asked to research the need and use of portals for our division due to budget cuts.

Currently, we are using MS SQL to develop and maintain databases and use ASP.NET in order to create and develop the webpages. We have a large audience, but the only about 5K of users depending on the application. The servers are running Windows 2000 as well. I would LOVE to have some resources that shows the pros and cons of using WebSphere, or if any of the members have any experience with WebSphere.

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

Date: 02/08/06 (MySQL Communtiy)    Keywords: mysql, sql

Hello,

I am having problems with the SELECT * INTO OUTFILE

I have already ensured that:
1) I have file access
2) the folder is chmod 777
3) the file does not already exist

My code looks like this:
$query="SELECT * INTO OUTFILE 'backup/$date.txt' FIELDS TERMINATED BY '\t' LINES TERMINATED BY '\n' FROM journal";
$result=mysql_query($query) or die(mysql_error());
if ($result) { echo "Backup file was created successfully!"; }

This is what I get when I run the script:
Can't create/write to file 'backup/07022006.txt' (Errcode: 2)

Any help would be greatly appreciated. Thanks!

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

Date: 02/07/06 (C Sharp)    Keywords: database, sql, web

C# 2005 Express Edition.

Okay, quickest way to explain this situation: I have a DataGridView attached to a local Access database. The DGV pulls in three columns. My goal here is to get changes in the columns to update to the table automatically a la an open Access table window (or SQL Server Entierprise Manager or FoxPro or... you know). I started with the code in this CodeProject article.

The first change I've had to make to it is that it seems I have to instantiate the tableadapter before calling its Update() method. All well and good, though I'm not sure I did it correctly. Make the change, run again, and same result: I can change stuff to my heart's content in the DataGridView, but none of the changes are propagated to the database. I added the MessageBox you see in the UpdateRowToDatabase method; it never fires.

My question (again assuming I instantiated the tableadapter correctly): do I also need to instantiate the bindingsource? If so, how, because I can't find anything about it anywhere online or in the help files?

If not, can someone give me some idea of what it is I'm doing wrong? Thanks.

Problem solved, thanks to 109. Except for one oddity I'm going to go squash now...

EDIT2: bloody hell. I THOUGHT I had it...

sequence of events.
1. Fire up proggy.
2. Change a few rows, varying what I change in any given row.
3. With each change, event fires. (This is a major step forward, anyway.)
4. Close form.
5. Open form again (from the main form that calls it).
6. Look for changes. They are still there.
7. Exit program.
8. Start program again.
9. Open form.
10. Check for changes made when program was previously running... and they're not there.
(I've also gone in through Access and looked; the changes are not propagating.)

It looks as if the ThisCategoriesTableAdapter.Update(LastDataRow) command is updating the DataSet rather than the database itself. But everything I've seen on MS' website says specifically that the Update command will, in fact, update the database.

Changes to the program code integrated below.

Thanks!

public partial class BrowseCategories : Form
{
    categoriesDataSetTableAdapters.CategoriesTableAdapter ThisCategoriesTableAdapter = new categoriesDataSetTableAdapters.CategoriesTableAdapter();
    //tracks PositionChanged event for last row
    private DataRow LastDataRow = null;

    public BrowseCategories
    {
        InitializeComponent();
    }

    private void BrowseCategories_Load (object sender, EventArgs e)
    {
        this.parentsTableAdapter.Fill(this.parents._Parents);
        this.categoriesTableAdapter.Fill(this.categoriesDataSet.Categories);
        this.dgCategories.AutoResizeColumns(DataGridViewAutoSizeColumnsMode.AllCells);
        //Is there a way to add an event handler from the design screen?
        categoriesBindingSource.PositionChanged += new EventHandler(categoriesBindingSource.PositionChanged);
        //Set LastDataRow initially, or if you try to change the first row, the event handler won't fire
        BindingSource thisBindingSource = (BindingSource)categoriesBindingSource;
        LastDataRow = ((DataRowView)thisBindingDource.Current)>Row;
    }

    private void UpdateRowToDatabase();
    {
        if (LastDataRow != null)
        {
            if (LastDataRow.RowState == DataRowState.Modified)
            {
                ThisCategoriesTableAdapter.Update(LastDataRow);
            }
        }
    }

    private void categoriesBindingSource_PositionChanged(object sender, EventArgs e)
    {
        BindingSource thisBindingSource = (BindingSource)sender;
        DataRow thisDataRow = ((DataRowView)thisBindingSource.Current).Row;
        if (thisDataRow == LastDataRow)
        {
            throw new ApplicationException("It seems the PositionChanged event has fired twice for the same row.";
        }
        UpdateRowToDatabase();
        LastDataRow = thisDataRow;
    }

    private void btnParent_Click(object sender, EventArgs e)
    {
        BrowseParent frmParent = new BrowseParent();
        frmParent.Show();
    }

    private void BrowseCategories_FormClosed(object sender, EventArgs e)
    {
        UpdateRowToDatabase();
    }
}
}
//I seem to have added an extra bracket... keeping it in case I screwed up the formatting somewhere.
As I retyped it all, assume any typos are unique to this rendition. The code does run (it just doesn't update the database).

EDIT:: as requested by 109 the InitializeComponent() method:

private void InitializeComponent()
{
    this.components = new System.ComponentModel.Container();
    this.dgCategories = new System.Windows.Forms.DataGridView();
    this.parentsBindingSource = new system.Windows.Forms.BindingSource(this.components);
    this.parents = new HospitalRates.Parents();
    this.categoriesBindingSource = new System.Windows.Forms.BindingSource(this.components);
    this.categoriesDataSet = new HospitalRates.categoriesDataSet();
    this.btnParent = new System.Windows.Forms.Button();
    this.btnCorrect = new System.Windows.Forms.Button();
    this.btnDone = new System.Windows.Forms.Button();
    this.btnSave = new System.Windows.Forms.Button();
    this.categoriesTableAdapter = new HospitalRates.categoriesDataTableSetAdapters.CategoriesTableAdapter();
    this.parentsTableAdapter = new HospitalRates.ParentsTableAdapters.ParentsTableAdapter();
    ///a word of explanation: the control below started out life as a text box column because
    ///I'm a forgetful bastard, and name hasn't changed because I'm lazy, as well.
    this.ParentsDataGridViewTextBoxColumn = new System.Windows.Forms.DataGridViewComboBoxColumn();
    this.CategoryDataGridViewTextBoxColumn = new System.Windows.Forms.DataGridViewTextBoxColumn();
    this.descriptionDataGridViewTextBoxColumn = new System.Windows.Forms.DataGridViewTextBoxColumn();
    ((System.ComponentModel.ISupportInitialize)(this.dgCategories)).BeginInit();
    ((System.ComponentModel.ISupportInitialize)(this.parentsBindingSource)).BeginInit();
    ((System.ComponentModel.ISupportInitialize)(this.parents)).BeginInit();
    ((System.ComponentModel.ISupportInitialize)(this.categoriesBindingSounrce)).BeginInit();
    ((System.ComponentModel.ISupportInitialize)(this.categoriesDataSet)).BeginInit();
    this.SuspendLayout();
    //
    //dgCategories
    //
    this.dgCategories.AutoGenerateColumns = false;
    this.dgCategories.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize;
    ///note: I swear, there's no extra indentation here!
    this.dgCategories.Columns.AddRange(new System.Windows.Forms.DataGridViewColumn[] {
    this.parentDataGridViewTextBoxColumn,
    this.categoryDataGridViewTextBoxColumn,
    this.descriptionDataGridViewTextBoxColumn});
    this.dgCategories.DataSource = this.categoriesBindingSource;
    this.dgCategories.Location = new System.Drawing.Point(14, 14);
    this.dgCategories.Name = "dgCategories";
    this.dgCategories.Size = new System.Drawing.Size(739, 393);
    this.dgCategories.TabIndex = 0;
    //
    //parents
    //
    this.parents.DataSetName = "Parents";
    this.parents.DataSchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema;
    //
    //categoriesBindingSource
    //
    this.categoriesBindingSource.DataMember = "categoriesDataSet";
    this.categoriesBindingSource.DataSource = this.categoriesDataSet;
    //
    //categoriesDataSet
    //
    this.categoriesDataSet.DataSetName = "categoriesDataSet";
    this.categoriesDataSet.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema;
    //
    //btnParent
    //
    this.btnParent.Location = new System.Drawing.Point(14, 432);
    this.btnParent.Name = "btnParent";
    this.btnParent.Size = new System.Drawing.Size(135, 36);
    this.btnParent.TabIndex = 1;
    this.btnParent.Text = "Add/Edit Parent";
    this.btnParent.UseVisualStyleBackColor = true;
    this.btnParent.Click += new System.EventHandler(this.btnParent.Click);
    //
    //btnCorrect
    //
    this.btnCorrect.Location = new System.Drawing.Point(215, 432);
    this.btnCorrect.Name = "btnCorrect";
    this.btnCorrect.Size = new System.Drawing.Size(135, 36);
    this.benCorrect.TabIndex = 2;
    this.btnCorrect.Text = "Correct Existing Data";
    this.btnCorrect.UseVisualStyleBackColor = true;
    //
    //btnDone
    //
    this.btnDone.Location = new System.Drawing.Point(617, 432);
    this.btnDone.Name = "btnDone";
    this.btnDone.Size = new System.Drawing.Size(1356, 36);
    this.btnDone.TabIndex = 3;
    this.btnDone.Text = "Done";
    this.btnDone.UseVisualStyleBackColor = true;
    //
    //categoriesTableAdapter
    //
    this.categoriesTableAdapter.ClearBeforeFill = true;
    //
    //parentsTableAdapter
    //
    this.parentsTableAdapter.ClearBeforeFill = true;
    //
    //parentsDataGridViewtextBoxColumn
    //
    this.parentsDataGridViewTextBoxColumn.DataPropertyName = "Parent";
    this.parentsDataGridViewTextBoxColumn.DataSource = this.parentsBindingSource'
    this.parentsDataGridViewTextBoxColumn.HeaderText = "Parent";
    this.parentsDataGridViewTextBoxColumn.Name = "parentDataGridViewTextBoxColumn";
    this.parentsDataGridViewTextBoxColumn.Resizable = System.Windows.Forms.DataGridViewTriState.True;
    this.parentsDataGridViewTextBoxColumn.SortMode = System.Windows.Forms.DataGridViewColumnSortMode.Automatic;
    this.parentsDataGridViewTextBoxColumn.ValueMember = "Parent";
    //
    //categoryDataGridViewTextBoxColumn
    //
    this.categoryDataGridViewTextBoxColumn.DataPropertyName = "Category";
    this.categoryDataGridViewTextBoxColumn.HeaderText = "Category";
    this.categoryDataGridViewTextBoxColumn.Name = "categoryDataGridViewTextBoxColumn";
    //
    // descriptionDataGridViewTextBoxColumn
    //
    this.descriptionDataGridViewTextBoxColumn.DataPropertyName = "Description";
    this.descriptionDataGridViewTextBoxColumn.HeaderText = "Description";
    this.descriptionDataGridViewTextBoxColumn.Name = "descriptionDataGridViewTextBoxColumn";
    //
    //BrowseCategories
    //
    this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F);
    this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;
    this.ClientSize = new System.Windows.Drawing.Size(772, 515);
    this.Controls.Add(this.btnSave);
    this.Controls.Add(this.btnDone);
    this.Controls.Add(this.btnCorrect);
    this.Controls.Add(this.btnParent);
    this.Controls.Add(this.dgCategories);
    this.Load += new System.EventHandler(this.BrowseCategories_Load);
    ((System.ComponentModel.ISupportInitialize)(this.dgCategories)).EndInit();
    ((System.ComponentModel.ISupportInitialize)(this.parentsBindingSource)).EndInit();
    ((System.ComponentModel.ISupportInitialize)(this.parents)).EndInit();
    ((System.ComponentModel.ISupportInitalize)(this.categoriesBindingSource)).EndInit();
    ((System.ComponentModel.ISupportInitalize)(this.categoriesDataSet)).EndInit();
    this.ResumeLayout(false);
}

Ah, the problem becomes clear... the event handler never registered...

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

Date: 02/09/06 (PHP Community)    Keywords: php, mysql, browser, sql, apache

Hi all, I recently landed a new job. The people that work there use Eclipse. I have been playing around with it to try and get a feel for it before I start next week and I am running into a couple of problems. I was hoping one of you would not mind giving me some pointers.

I have:

Eclipse Version: 3.1.2
XAMPP very 2.1

I installed Eclipse into the XAMPP directory as instructed.

To my understanding XAMPP will run Apache, MySql, PHP and PERL when the computer starts as I think I set them up as services.

I wrote a little test program using a set of functions that I have been using for a while now. The test program includes a config file that has the full include list in it. For some reason none of my files are being included. I do a require instead of an include, it does not fail but the functions are still not available. I can see the files are the in Eclipse's browser so I am not sure why they are not being found.

There are buttons in Eclipse for starting and stopping XAMPP. These seem to have no effect on XAMPP at all.

Any clues suggestions would be helpful. I have looked on the net all day but have not found anything I can really seem to understand. I have read the help files for Eclipse but they only pertain to Eclipse itself and not the add ons.

cross posted*

Thanks

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

Date: 02/09/06 (PHP Community)    Keywords: php, mysql, sql

i've written this function (below), it takes

{TEXT1}
dfhdfkldfds;hdsfjsdfsdkfsdjkfhdsfsdjkfhdfjkdsfdsjkhd

{TEXT2}
fdkfdhfsldkfhdsfjlkhfdkjlfhdjkfldslkjfhsdhfldsfjhdsf

php

php_mysql

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

Date: 02/09/06 (PHP Development)    Keywords: php, mysql, browser, sql, apache

Hi all, I recently landed a new job. The people that work there use Eclipse. I have been playing around with it to try and get a feel for it before I start next week and I am running into a couple of problems. I was hoping one of you would not mind giving me some pointers.

I have:

Eclipse Version: 3.1.2
XAMPP very 2.1

I installed Eclipse into the XAMPP directory as instructed.

To my understanding XAMPP will run Apache, MySql, PHP and PERL when the computer starts as I think I set them up as services.

I wrote a little test program using a set of functions that I have been using for a while now. The test program includes a config file that has the full include list in it. For some reason none of my files are being included. I do a require instead of an include, it does not fail but the functions are still not available. I can see the files are the in Eclipse's browser so I am not sure why they are not being found.

There are buttons in Eclipse for starting and stopping XAMPP. These seem to have no effect on XAMPP at all.

Any clues suggestions would be helpful. I have looked on the net all day but have not found anything I can really seem to understand. I have read the help files for Eclipse but they only pertain to Eclipse itself and not the add ons.

cross posted*

Thanks

Source: http://community.livejournal.com/php_dev/65019.html

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

Hi all,
I'm new to SQL Server, I'm an Oracle developer but have been handed a project to convert some reports to run against a SQL Server database using Crystal Reports. Is there anyone here with experience in developing Crystal Reports against a SQL server database that I can bounce a couple of basic questions off?

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

Date: 02/10/06 (MySQL Communtiy)    Keywords: mysql, software, sql, web, google

Hi...

I have googled, dev.mysql.com'ed, RTFM and stuff, and I'm a little frustrated, I hope someone here knows the definitive answer.

We developed our web-based software on version 3.23.41 where the timestamp format is YYYYMMDDHHMMSS, I'm sure you know the drill.

Now, we're migrating to a new server, with 4.1.12 and the timstamp default format is %Y-%m-%d %H:%i:%s

The big question: Can I change this version of MySQL (I do have root access) to use the old type of timestamp format?

If so, How? Or, can you point me to a resource that explains it?

Again, I have tried google, dev.mysql.com, etc. I apologize if this is a dumb question, but so far all sources point to it just being the format and nothing I can do. I kinda don't believe that, as it sounds like an inflexibility that would cause other developers to run into problems upgrading....unless of course, I am doing it all wrong!

Any help is appreciated.

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

Date: 02/12/06 (MySQL Communtiy)    Keywords: mysql, sql

The Boston-area MySQL Meetup group is going strong with over 150 members! (20-50 show up each meeting) This month features a change in location, so now we have close subway access AND FREE PARKING. We are supported by MySQL AB, who provides pizza and soda.

This meetup group is totally free. There are benefits including discounts on O'Reilly books (30% off!) and prizes. The topic for the meeting on Monday, February 13th is "So You've Inherited a MySQL Instance". It will be useful for beginners, and experience MySQL users will refresh their memory on what needs to be secured.

It has a unix focus, but most of the ideas can be applied to Windows users as well.

Afterwards, we'll head to the Cambridge Brewing Company for more discussion and chatting.

More details, including the event location, directions and parking, are at:
http://mysql.meetup.com/137/events/

I encourage you to sign up for the meetup group, as I may not post here every month.

Previous Boston MySQL meetup presentations can be found under the "Presentations" link at http://www.sheeri.com

Any questions, comments, etc should be sent to me.

You may forward this announcement to other groups, lists, blogs, whatever.

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

Date: 02/14/06 (Web Development)    Keywords: mysql, database, asp, sql

Hey all,

I'm an idiot when it comes to ASP, just just starting, and don't know VBScript either (which is what this developer used). I'm trying to use some of his code for some other database functions to grab different data (which I've tried to modify it to get) but I don't know where I'm going wrong. It's in SQL, not MySQL, too. Any clues? I need to display a list of Transcripts, where the url is TranscriptURL and the Event Title is sEventTitle. Am I collecting the data wrong? Are the loops/connections messed up?

'* Get the name of the videoURL and transcriptURL. '* Now get the data. Dim oConnection Set oConnection = Session("oConn") '* Build the select statement. sSQL = "SELECT VideoURL, TranscriptURL, Title, [Date] FROM IOP_Events WHERE TranscriptURL != "" " '* Now create a Recordset object. set rstTemp = Server.CreateObject("ADODB.Recordset") rstTemp.ActiveConnection = oConnection rstTemp.Open sSQL, oConnection '* Set the variables for the data. with rstTemp if not .eof then '* Set the videoURL (wont always have one). sVideoURL = trim(.fields("VideoURL").value & "") '* Check for the transcriptURL now. if trim(.fields("TranscriptURL").value & "") <> "" then '* We have a transcript so set it. sTranscriptURL = trim(.fields("TranscriptURL").value else '* Now transcript available. sTranscriptURL = "" end if '* Set the event title and date. sEventTitle = trim(.fields("Title").value & "") sEventDate = trim(.fields("Date").value & "") end if end with '* Clean up. rstTemp.close set rstTemp = nothing '* Setup the connection. Dim oConnection Set oConnection = Session("oConn") '* Now create a Recordset object. set rstTemp = Server.CreateObject("ADODB.Recordset") rstTemp.ActiveConnection = oConnection rstTemp.Open sSQL, oConnection '* Write out all the data now. iColumnNumber = 1 iRowNumber = 0 with rstTemp do while not .eof if iColumnNumber = 1 then '* Write out the first record in the first column. '* Use alternating row colors. iRowNumber = iRowNumber + 1 if iRowNumber mod 2 = 0 then Response.write ("<tr class=""tan_bg"">") else Response.write ("<tr class=""results_text"">") end if '* Write out the record now. Response.write ("<td><a href=" & sTranscriptURL & """>" & trim(.fields("sEventTitle").value & "") & "</td>") iColumnNumber = 2 else '* Write out the record now. Response.write ("<td><a href=" & sTranscriptURL & """>" & trim(.fields("sEventTitle").value & "") & "</td></tr>") iColumnNumber = 1 end if '* Now write out the second write in the second column. .movenext loop '* If we didn't get any rows write out message. if iRowNumber = 0 then Response.write ("<tr class=""results_text""><td>None specified</td></tr>") end if '* Add last tr closing tag if we ended writing to column 1. Response.write ("<td> </td></tr>") end with '* End the table now. Response.write ("</table>") '* Clean up. rstTemp.close set rstTemp = nothing
Anyone who doesn't feel like dealing with it can also just point me in the way of a quickstart ASP/VBscript guide, as well (online better).

Jess

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

Date: 02/14/06 (SQL Server)    Keywords: sql

Anybody use Apex SQL Edit? If so is it worth the money? If not, any recommendations? I have Tried SQL Buddy and SQLPrompt but I am looking for a robust SQL IDE Solution.

Any Input would be great.

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

Date: 02/15/06 (MySQL Communtiy)    Keywords: mysql, html, sql

Given the following schema, the following datasets are defined:

A procedure is a collection of testcases, a plan_procedure is a collection of plan_testcases which reflect a temporal snapshot of a procedure collection.

So my question is, given a procedure.id and plan_procedure.id, how do I show the differences between a procedure and a plan_procedure? i.e. show missing testcases from plan_testcases and vice versa? I have been studying the docs on LEFT JOINS and am having problems grokking this one.

Schema follows:

CREATE TABLE `procedures` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `procedure_name` varchar(80) NOT NULL default '',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `procedure_name` (`procedure_name`)
);

CREATE TABLE `testcases` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `procedure_id` int(10) unsigned NOT NULL default '0',
  `procedure_steps` text NOT NULL,
  `expected_results` text NOT NULL,
  PRIMARY KEY  (`id`)
);

CREATE TABLE `plan_procedures` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `procedure_id` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`)
);

CREATE TABLE `plan_testcases` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `plan_procedure_id` int(10) unsigned NOT NULL default '0',
  `testcase_id` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`)
);

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