Date: 01/05/07 (SQL Server)    Keywords: database, sql

Hi all. Does anyone on this group have any experience in either Bulk Loading, ETL, or Replication between a SQL 2005 database and a DB2 database. There is a known problem with the translation of a VARGRAPHIC (db2 datatype) to SQL 2005, so I'm trying to find the best workaround for a datafile that is about 2 GIG. I know it's a long shot but I thought I'd holler. If I figure it out, I'll post my findings for benefit of the group.

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

Date: 01/06/07 (PHP Community)    Keywords: php, browser, database

Hello everyone,

I realise lately whenever i refresh the upload.php page, the browser will keep uploading the file into my database. How to come up with a code that can make the browser check if the file exist in database, if doesn't exist, then shall upload to database?

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

Date: 01/09/07 (Java Web)    Keywords: database, java, security

Security vendor Imperva has identified an access-control vulnerability in DWR, Java Open Source AJAX development framework (stable release 1.1.3 and 2.0), which it says an attacker can use to compromise a DWR based application which may in turn enable him to say break into back-end databases or servers or launch a denial-of-service-attack. On a positive note [...]

Source: http://blog.taragana.com/index.php/archive/analysis-security-vulnerability-discovered-in-dwr-open-source-java-ajax-development-framework/

Date: 01/11/07 (SQL Server)    Keywords: database, sql

I've asked this question before in a vaguely similar form. Still beating my head against the problem when I get a few minutes free.

Is it possible to:

1. Set the destination table in a transform data task, and
2. Set up the transformations in a transform data task

...in an ActiveX Script task in the same DTS package (SQL Server 2000)? I've read a few extremely vague forum posts on a few disparate boards that make me believe this is possible. When I try the first, though, I always seem to modify the database name the package is pointing to, rather than the table within the database.

Function Main()

	dim pkg
	dim conTextFile 
	dim conSQLDest
	dim stpEnterLoop
	dim stpFinished

	dim intLocation1
	dim intLocation2
	intLocation1 = instrrev(DTSGlobalVariables("gv_FileFullName").Value, "\")
	intLocation2 = instr(DTSGlobalVariables("gv_FileFullName").Value, ".")

	DTSGlobalVariables("gv_FileTableName") = Mid(DTSGlobalVariables("gv_FileFullName").Value, intLocation1+1, intLocation2-intLocation1-1)
	msgbox "FileTableName: " & DTSGlobalVariables("gv_FileTableName").Value

	set pkg = DTSGlobalVariables.Parent
	set stpEnterLoop = pkg.Steps("DTSStep_DTSDataPumpTask_1")
	set stpFinished = pkg.Steps("DTSStep_DTSActiveScriptTask_5")
	set conTextFile = pkg.Connections("Text File (Source)")
	set conSQLDest = pkg.Connections("SQLServerDestination")

	' We want to continue with the loop only of there are more
	' than 1 text file in the directory.  If the function ShouldILoop
	' returns true then we disable the step that takes us out of the package
	' and continue processing

	if ShouldILoop = True then
		stpEnterLoop.DisableStep = False
		stpFinished.DisableStep = True
		conTextFile.DataSource = DTSGlobalVariables("gv_FileFullName").Value
		conSQLDest.DataSource = "[XTend_Load].[dbo].[" & DTSGlobalVariables("gv_FileTableName").Value &"_JU]"
		Msgbox "Destination: " & conSQLDest.DataSource
		stpEnterLoop.ExecutionStatus = DTSStepExecStat_Waiting
	else
		stpEnterLoop.DisableStep =True
		stpFinished.DisableStep = False
		stpFinished.ExecutionStatus = DTSStepExecStat_Waiting
	End if

	Main = DTSTaskExecResult_Success
End Function

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

Date: 01/11/07 (MySQL Communtiy)    Keywords: mysql, software, database, sql, web

I am running MySQL 4.1.22 on Windows 2000, and I'm having problems with European characters.

When data is input through the software that uses it, European characters are converted into strange symbols that may or may not display properly in a web context. For instance É looks like É in the database, ü comes out as ü.

When I input the data through SQLyog, everything from the first European character to the end of the string is cut off.

I am using utf8_general_ci, which is how the software set up the database. What am I doing wrong, or what else should I be looking for?

Thanks for any help you can offer.

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

Date: 01/11/07 (Web Development)    Keywords: php, mysql, css, html, database, sql, web

I run a fan website and I'm currently having a problem with the navigation menu in one section.

The section is PHP/MySQL based (the other parts of the site are static HTML at the moment) and can be found here: http://www.selenayhaven.com/reviews/ It's the green left-hand navigation side bar that has problems reported. It uses unordered lists and CSS to acheive the 'button' appearance, following a tutorial from A List Apart. It works absolutely fine on all the instances of Firefox, Opera and IE that I've tested it on and other users report that it works in Safari. However, one user reports that the menu doesn't work when she clicks on it and I honestly cannot work out why.

Menus in the rest of the site (e.g. http://www.selenayhaven.com/gate/index.html) were constructed slightly differently (no lists) and my user has no problem with them. I decided to do them differently when I set up the database area because I thought it would be better from an accessibility POV - how wrong I was, apparently!

My query is whether anyone else using Firefox cannot use the problem navigation menu and whether anyone can suggest how I might be able to fix it. I'm about to start sorting out the site to accommodate IE7, so I want to make sure that I'm starting with a site that works properly before making yet more changes. My problem user has tested the site in both Firefox 1.5 and 2.0.

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

Date: 01/12/07 (PHP Community)    Keywords: php, mysql, database, sql, web

Hello! This is my first post on LiveJournal.
I'm making a website for the group that I'm in, and I have a little bit of self-taught PHP & MySQL experience, but I'm up to the point of making the administration section so we can update the site without any hassle.

All I need is a little bit of a push to start me rolling (so to speak)
Any help is appreciated and will get a spot in the credits for the site.

What I need is:
*Admin Login.
*Posting Support.
*Managing of posts.
*Page authoring (eg... projects.php?id=XX (where 'XX' is projects name)).
*News authoring.

(MUST INCORPORATE MYSQL DATABASE!)

Any little bit of code would be great, just as long as it gets me started!
Thank you!

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

Date: 01/13/07 (Web Development)    Keywords: database, java, web

I just launched a new version of the corporate website for my employeer. I did not design it or code the flash-based components. I did much of the database work and the java back-end. I would appreciate comments from fellow developers.

http://www.dressbarn.com

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

Date: 01/14/07 (Web Development)    Keywords: software, database

Looking for anyone's experience in coming up with some sort of deployment system to bring together 4 different programmers on a project that needs to be built rapidly.

I am pretty well versed in subversion, but the way the lead of my new company is explaining, the individual developers will need to be able to modify the site's core library at will. And the concern with this is, what if one developer breaks a needed component...suddenly the other 3 programmers are at a work stoppage until it's fixed. So he suggested creating 4 branches of the main repository for the other dev's and me. This way each Dev has their own code base to modify at will. This seems a little crazy, but maybe I am missing something here.

From my understanding, you can remerge different branches together...but to do so requires manually walking through diff's of conflicting revisioned files. So unless we merge all 4 branches on a weekly basis, this will be one massive cluster -ck eventually at the end.


Some quick thoughts on my own:
Dedicating one of the 3 programmers to developing the core library, basically giving him/her a "I need this functionality" memo or something.

Coming up with some sort of per-file branching scheme when a dev has to edit a library/base system.



Any comments or suggestions would be greatly appreciated.

Update

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

Date: 01/15/07 (Computer Geeks)    Keywords: mysql, software, database, sql, web, linux, microsoft

I'm trying to find something that will do approximately what Microsoft Project does, without actually being Microsoft Project ... Things I'd be looking for (ordered approximately from most important, to least important...):

Date: 01/16/07 (WebDesign)    Keywords: php, mysql, database, sql, web, linux, hosting, apache

1) Can anyone recommend any reliable and not too expensive UK based webhosting companies?
(only hosting, no domain name registration needed)


Necessary features:
- Linux/Apache server
- at least 150MB webspace
- bandwith/traffic on a normal scale, the more the better *g*
- PHP (version 4 okay, 5 better)
- at least one MySQL database
- FTP access and several email accounts should be a given

A plus, but not really neccessary:
- .htaccess
- cgi/perl
- shell access

2) DreamHost as a webhost for a small business website?
I do have a DreamHost account, mostly for dabbling around and trying out stuff, and love all their features (and low prices). But although I've never had any problems so far, hearing every now and then about down times or bad customer service makes me a bit reluctant to recommend them to a client for hosting their small business website. Opinions, anyone?

Thanks! :-)

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

Date: 01/16/07 (PHP Community)    Keywords: php, mysql, database, sql, web, linux, hosting, apache

Can anyone recommend any reliable and not too expensive UK based webhosting companies?
(only hosting, no domain name registration needed)

Necessary features:
- Linux/Apache server
- at least 150MB webspace
- bandwith/traffic on a normal scale, the more the better *g*
- PHP (version 4 okay, 5 better)
- at least one MySQL database
- FTP access and several email accounts should be a given

A plus, but not really neccessary:
- .htaccess
- cgi/perl
- shell access

ETA: Is DreamHost a recommendable webhost for a small business website?
I do have a DreamHost account, mostly for dabbling around and trying out stuff, and love all their features (and low prices). But although I've never had any problems so far, hearing every now and then about down times or bad customer service makes me a bit reluctant to recommend them to a client for hosting their small business website. Opinions, anyone?

Thanks! :-)

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

Date: 01/16/07 (Web Development)    Keywords: php, mysql, database, sql, web, linux, hosting, apache

Can anyone recommend any reliable and not too expensive UK based webhosting companies?
(only hosting, no domain name registration needed)

Necessary features:
- Linux/Apache server
- at least 150MB webspace
- bandwith/traffic on a normal scale, the more the better *g*
- PHP (version 4 okay, 5 better)
- at least one MySQL database
- FTP access and several email accounts should be a given

A plus, but not really neccessary:
- .htaccess
- cgi/perl
- shell access

Addendum:I just saw that in this comm's user info DreamHost is recommended as a webhost.
I do have a DreamHost account, mostly for dabbling around and trying out stuff, and love all their features (and low prices). But although I've never had any problems so far, hearing every now and then about down times or bad customer service makes me a bit reluctant to recommend them to a client for hosting their small business website.
Opinions, anyone?

Thanks! :-)

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

Date: 01/17/07 (PHP Community)    Keywords: php, mysql, html, database, sql

I'm trying to create a super basic login page.. one that doesn't require a mysql database of usernames and passwords, which apparently is nearly impossible to find. I'm still relatively new to php.. bumbling along mostly. Anyway.. here's what I've got so far



In the first page of the protected section:

session_start();
if (isset($_POST['user'])) {
$_SESSION['username'] = $_POST['user'];
$_SESSION['password'] = $_POST['pass'];
$_SESSION['authuser'] = 0;
}
//check username and password information
if (($_SESSION['username'] == 'bob') and
($_SESSION['password'] == 'smith')) {
$_SESSION['authuser'] = 1;
} else {
echo "Sorry, but you don't have permission to view this page, Try Again";
exit();
}
?>

session_start();
if ($_SESSION['authuser'] = 1) {
?>

html stuffs

else {
echo "Sorry, but you don't have permission to view this page, Try Again";
exit();
}
?>

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

Date: 01/20/07 (Web Development)    Keywords: oscommerce, database

I am working on a design for an e-commerce site. Currently my company uses a bastardized version of osCommerce. It's very broken, thanks to many developers/contractors that we used prior to my hiring, we want to fix out commerce site, but do not want to use osCommerce due to many limitations that we have run into with our business model.

That said, I am working on the database schema for the site, and am working on the administrative part of the site first. Basically the ability to create products/categories, edit order data, and create new administrative users. What I am kind of stuck on is the best way to handle admin user permissions.

I've thought of 3 methods to do this.

1. Create a list of actions that can be done, and create a map and map them to the users.


2. Create a list of user groups and allow admin users be mapped to the group.


3. Create a list of actions that can be done and allow them to be mapped to the groups, and allow those groups be mapped to the users.

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

Date: 01/29/07 (Security)    Keywords: database

New database combines state registries; National Center for Missing & Exploited Children says it will use information to help law enforcement.

Source: http://news.zdnet.com/2100-1009_22-6154208.html

Date: 02/04/07 (PHP Community)    Keywords: database

what im looking for is a script to find out who in my database is available/online and put their ad on the main page. sort of like at the bottom of forums where its says who is active, but with a photo and link. super simple. let me know how much. edanya at edanya dotcom :o)

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

Date: 02/05/07 (PHP Community)    Keywords: php, database

I have the script which allows to register new users (field 'nick' in data base) and set their default status as "simpleuser" (field 'stat' in data base). And I want a page where all new users with status "simpleuser" will be listed one after another in table. And near each nick will be form where I could select a user's new status ('moderator' or 'administrator'). And after this table will be a button for subnision which updated database with new values.

I've wtitten code. But it doesn't work :(

So, it consists of two files [B]sending.php[/B] and [B]user_submit.php[/B].

sending.php

include('connection.php');

$query = "SELECT id, nick, email FROM test WHERE stat = 'newuser'";
$result = mysql_query($query) or die("ERROR: $query.".mysql_error());

// if records are present
if (mysql_num_rows($result) > 0) {
    $row = mysql_fetch_assoc($result);
    $id = $row->id;

    echo ""; 
        echo "";
        echo "";  
        echo "

".$row[nick]."

".$row[email]."</a>

";
    echo "";
   
        echo "
    administratorn>
    moderator

    echo "";
    echo "";
    echo "";
 }

else {
    echo 'No new users';
}

// close connection
mysql_close($connection);

?>

Problem here:
There is only one user shown in the table, but in the db there're many of them. Why does it show only one?

user_submit.php

if (isset($_POST['submit'])) {

    include('connection.php');
   
    $result = mysql_query("UPDATE test SET stat = '{$_POST['newstat']}'  WHERE id = '{$_POST['id']}'");
    // close connection
    mysql_close($connection);

    // print success message   
    echo 'Done';
}
else {
    die('ERROR: Data not correctly submitted');
}

?>

The problem here is:
It doesn't set new status to users. But I'm not sure that mistake which causes this problem in user_submit.php, it might be in sending.php

Help me please.

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

Good Asp.Net 2.0 hosting?

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

I'm looking to set up a website that will take control of another web site in about 10 months. I want it to be .net based, so I need a 2.0 provider. I would like a plan that includes purchasing the hostname, and one that has access to a database. Does anyone have any experience with some providers being better than others?

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

limiting data fetched

Date: 02/08/07 (MySQL Communtiy)    Keywords: database

Let's say I have a message IDs like this sequence extracted from a database.

1
2
3
4
5
6
7
8
9
10
27
28
29
30
39
45
58
59
60
63

If I want to select the first 10 data, it's easy with LIMIT 0,10.

But, how do I select the second 10 data when it goes random? And third and fourth and the rest?

Is there a simpler way than putting out the last ID in a cookie?

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

Previous page

||

Next page