Date: 04/21/05 (Java Web)    Keywords: database, google

I have been a Google fan from his early search days when people still used say - have you checked Google. Google had a small database. Altavista was still the leader and dotcom was still booming. I tried GMail account, guess wasn't elite to be invited to Orkut, used Google Maps and Google Suggest etc. [...]

Source: http://blog.taragana.com/index.php/archive/sorry-google-i-draw-the-line-here/

Date: 04/24/05 (Computer Help)    Keywords: database, web

I'm sure this community gets a lot of this, but here's my introductory post, and I've got a slew of problems for anyone willing to address them. The most terrible thing for me about these problems is that I find myself to be pretty competent as far as fixing computers goes, so these issues kill my ego.

For reference purposes, this computer is a slightly dated Compaq notebook running XP Service Pack 2.]

I'm sort of afraid of heckling, but I guess I can't get much worse than that Jesus icon asking how to reduce the column size of the taskbar. Hopping right to it:

Problem A: I just bought this great new 19" LCD display from Envision. It works fine, in fact I'm using it right now. However, it has this terribly annoying flicker. The flicker itself isn't that of a monitor going out, rather it looks like it's running the wrong refresh rate (which I have checked out already) so there's sort of a pulsing brightness. Now before I go any further, I must say that I'm absolutely positive this is a driver issue. I have the original CD as well as the most recent driver available from Envision's website. My assumption here is that the problem lies not in the monitor or driver itself, the problem is 'pointing' the computer towards the right driver. (The monitor works fine on my parents' G4 and G5.)

Problem B: I have this old 40 gig Maxtor 3000DV External Hard Drive that is extremely problematic. From what I've read, it's awfully common for system with XP to stop reading these. I'm pretty sure that this is a driver issue as well, but I just can't find a driver. I'm still rooting around for my original disc, but it was a hand me down from my dad, so it's probably at his office. If anyone has faced a similar problem with their Maxtor externals and p'raps has a link to a driver database, that would be great.

Problem C: This isn't really a problem so much as a goddamn nuisance. I have a great 40 gig iPod+HP. It works just fine, but it prompts me to reformat it every few months or so. This really sucks, especially when it occurs after I plug it into my friends' computers for a quick upload. I guess my only question here is have any of you experienced issues with your iPod+HP devices?

Thanks in advance everyone.

Source: http://www.livejournal.com/community/computer_help/382457.html

Date: 04/26/05 (PHP Community)    Keywords: php, mysql, html, database, sql, web

I'm trying to do some really wacky stuff with a form.

Essentially, I'm reading in multiple columns from a table in a MySQL database (looping, obviously), and creating a form as I present the data. The challenge this presents is that for each loop, the form values have to have a unique identifier, so I'm trying to use variables. It's not working so well, but I'm using standard HTML to try to process the form. I've gleaned bits and pieces searching the web that PHP has its own method to handle form input.

So, I need a good book that has a lot of detail on how to work with forms. A good web resource would work too.

Thanks in advance!



This is a quick mockup of the code and how I'm presenting the form...

$count=0; while(list($name, $id, $message)= $result->fields) { echo "<input name=\"name$count\" value=\"Y\" type=\"checkbox\">$name<br>"; echo "<input name=\"id$count\" value=\"Y\" type=\"checkbox\">$id"<br>; echo "<input name="\msg$count\" value=\"$message\" type=\"hidden\">$message<br>"; $count++; $result->MoveNext(); }

So, in theory here, each loop should give a unique value to each form element. I just need to know how to process it. I'm writing selected data back into a seperate table, so I need to loop through the results and write them out.

Again, help is appreciated!

Source: http://www.livejournal.com/community/php/291348.html

Date: 04/27/05 (C Sharp)    Keywords: database, sql, web, tracker

AxoSoft OnTime defect tracker

I thought I'd bring this nifty app to your attention. I'll start by saying that I'm not affilated with AxoSoft, I just happened upon their site one afternoon and found that they offer their bug tracking tool free of charge for single-user installations. They basically offer a Windows client, Web client and VS.NET client and database backend to a well featured bug and new feature tracking tool. It utilises a SQL Server database, so you'll need either a version of MSDE or SQL Server Personal Edition but obviously they're availble free of charge too.

After you've installed it, you can get a product key from the site to unlock the tool(s) you've installed indefinitely. I realise that outside of a team environment lone Developers often find it unnecessary to use such a tool, but I've found it to be pretty useful since installing it. So, I suppose YMMV :)

Source: http://www.livejournal.com/community/csharp/27649.html

Date: 04/27/05 (Asp Dot Net)    Keywords: database, sql, web, tracker

AxoSoft OnTime defect tracker

I thought I'd bring this nifty app to your attention. I'll start by saying that I'm not affilated with AxoSoft, I just happened upon their site one afternoon and found that they offer their bug tracking tool free of charge for single-user installations. They basically offer a Windows client, Web client and VS.NET client and database backend to a well featured bug and new feature tracking tool. It utilises a SQL Server database, so you'll need either a version of MSDE or SQL Server Personal Edition but obviously they're availble free of charge too.

After you've installed it, you can get a product key from the site to unlock the tool(s) you've installed indefinitely. I realise that outside of a team environment lone Developers often find it unnecessary to use such a tool, but I've found it to be pretty useful since installing it. So, I suppose YMMV :)

Source: http://www.livejournal.com/community/aspdotnet/32809.html

Date: 04/28/05 (PHP Community)    Keywords: mysql, rss, html, xml, database, sql

Alright, I'm having a bit of a problem.

I've set up a page to read and parse RSS feeds. It works for the most part. The feed names and addresses are pulled from a mysql database okay. The problem lies in putting them onscreen. At some point, variables are not being dropped or overwritten, and I'm getting the same results repeated, but with the count number of the second feed.

See what I mean?

This is the code:


-- Begin Code --



include (" [ sql stuff ]");

$sql = "SELECT * FROM rss_feeds";

$results = mysql_query($sql);

while ($myrow = mysql_fetch_array($results))
{


$feedtitle = $myrow['name'];
$feedurl = $myrow['url'];
$xfeed = $myrow["feed"];
$maxcount = $myrow['num_items'];


$xmlfile = fopen("$xfeed", "r");
if(!$xmlfile)die("This doesn't work");
$readfile = fread($xmlfile ,100000);
$searchfile = eregi("< item>(.*)< /item>", $readfile ,$arrayreg);
$filechunks = explode("< item>", $arrayreg[0]);
$count = count($filechunks);

if ($maxcount > $count)
{
$maxcount = $count;
}


echo "< a href=\"$feedurl\">$feedtitle< /a>< br>";


for($i=1 ; $i<=$maxcount ; $i++)
{


eregi("< title>(.*)< /title>",$filechunks[$i], $title);
eregi("< link>(.*)< /link>",$filechunks[$i], $link);
eregi("< pubDate>(.*)< /pubDate>",$filechunks[$i], $pubdate);
eregi("< description>(.*)< /description>",$filechunks[$i], $description);

$pubdate = "$pubdate[1]";
$xlink = "$link[1]";
$xtitle = "$title[1]";
$xdescription = "$description[1]";

$xdescription = html_entity_decode($xdescription);
$xdescription = strip_tags($xdescription);


$xday = substr($pubdate, 5, 2);
$xmonth = substr($pubdate, 8, 3);
$xyear = substr($pubdate, 12, 4);

$monthnames = array("Jan", "Feb", "Mar", "Apr", "May", "Jun", "Jul", "Aug", "Sep", "Oct", "Nov", "Dec");
$monthnumbers = array("01", "02", "03", "04", "05", "06", "07", "08", "09", "10", "11", "12");

$ymonth = str_replace($monthnames, $monthnumbers, $xmonth);

$articledate = date("F jS, Y", mktime(0, 0, 0, $ymonth, $xday, $xyear));

echo "< span style=\"text-transform: capitalize;\">< a href =\"$xlink\" target=\"_blank\">$xtitle< /a>< /span>< br>";
echo "$articledate< br>";
echo "$xdescription< br>";

}

}


-- End Code --



Anyone have any idea what could be causing this?

NOTE: It looks now to be a problem with the one RSS feed itself, and not the code

Source: http://www.livejournal.com/community/php/292485.html

Date: 04/28/05 (C Sharp)    Keywords: database, asp, web

It's time for another round of questioning from julisana!

Alright. I'm not sure if this question would be more suited in aspdotnet, but I figured I'd ask here, anyway. I've got a web application, with an external data access layer for connecting and accessing a database. The problem I'm running into is this:

What's the best way to connect the data layer to the pages!

Also, and this is just a dumb little piddly question: Seeing how this is a web application, should the file format for my data layer be *.cs or *.aspx?

Thanks so much!
--Lisa

Source: http://www.livejournal.com/community/csharp/27967.html

Date: 04/28/05 (PHP Community)    Keywords: php, mysql, database, sql, web, linux, hosting

I have a hosting company that runs Linux with PHP and MySQL through Plesk (a kind of server control panel) I can’t get into the control panel at work because I’m behind a firewall that blocks port 8443. I can, however use “my network places” in windows 200 to create an FTP connection to my server. The down side is: with FTP I can’t interface with the MySQL database… but, at least, I can upload and download files…Right?

Wrong.

This is the weirdest thing I’ve ever seen. The files I upload using FTP on my home computer or Plesk at home can be accessed from the web by typing the URL, but they do not appear in windows FTP flooder for the site. Yes, I have refreshed and restarted and connected and disconnected. They just don’t show up.

I can copy a file in to the FTP folder in windows… and it returns no error and appears to have uploaded correctly. But, if I type in the URL for the file the server says “file not found” I believe the upload is not working because when I go home and look in FTP on the other side of the firewall the file is not there! But, it appears to be there in windows. It was even there the next day. What on earth is going on!

Moreover, if I use a web-based FTP like http://01ftp.com/index.php it will show be a different set of files depending on what side of the firewall I’m on.

I can’t turn the firewall off but I’d like to, at least, understand why this is happening.

Why didn’t windows return an error when the file failed to upload? What if that file had been important? How can it show the file in the FTP folder for my site when it’s not really there? I think that’s a pretty scary and unreliable thing for an OS to do!

I think this might have something to do with actve and passive FTP... I'm reading up on it now... but honestly I don't have a clue.

The firewall is Mcaffe desktop firewall, and it's centrally controlled so no way to shut it off without being some kind of evil little haXX0r.

Source: http://www.livejournal.com/community/php/293012.html

Date: 04/30/05 (PHP Community)    Keywords: php, mysql, database, sql

I'm working on redesigning the layout of a site I created not long ago.  I'm using the same database and all the same funcions and whatnot, I'm just changing the layout.

Seems easy enough, right?  No.  The code that works fine and dandy on the old version of the site is causing errors on the new version.  All I did is copy the php files containing the code to connect to the database and the functions that I use to populate the main page (look at the old version, you'll see what I mean).

So how come on the new site, the code that worked fine before, gives me the following errors?


Warning: mysql_query(): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) in [php file] on [line number]

Warning: mysql_query(): A link to the server could not be established in [php file] on [line number]
Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

The two versions of the site are on the same server, in different folders.  Also, other parts of the new site that connect to the same database work fine.  It seems (so far) that the error is only when I call the function to populate the main page.

Any ideas?

Source: http://www.livejournal.com/community/php/293204.html

Date: 05/04/05 (PHP Development)    Keywords: database, web

Ok i have a website and I'm trying to take a database my friend was using and make it so others can go online, log in and then enter in data. The thing is I need to design a login that creates something that while they are logged in, it enters the record of the database with their ID and only shows them their ID. Any ideas? I have dreamweaver MX2004 and I do know basics.

Source: http://www.livejournal.com/community/php_dev/56468.html

Date: 05/10/05 (MySQL Communtiy)    Keywords: mysql, database, sql, web

I inherited a site with a mysql back-end. It was rather painful to get a understanding of what the heck the previous person was doing (it was not pretty). So adding to the db was ok, and making a slight modification here and there was ok. Now the pain came. The client wants to be able to search the database via part numbers (and then return the page it is on). I think to my self, hey no problem right?
bzzt wrong.
I have PartNumber, partnumber, quarter_partnumber and half_partnumber; also each product category is its own table in the database (for a total of ~45 tables). I have done some reading up on this and I believe a join could help.
now, should I bother with a huge join, try to search each table by its self (time wise very costly), or ?
let alone once I find the correct partnumber I have to then find a way to attach the webpages (a second db or a new field in each record).

my brain hurts with the stupid

Source: http://www.livejournal.com/community/mysql/56150.html

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

...on the same VBScript thing I'm trying to come up with in DTS. I'm sure this is another "it's very obvious, you just haven't put the piece together correctly" kind of question.

Okay, to recap fast: I'm importing a text file and shunting each record off into one of a series of possible places for some quick processing (I'm keeping the test cases in the SELECT CASE statement to the simplest possible options, so I can make sure I have a running skeleton before getting into any more complex processing)-- right now, it's simply splitting the line and copying it into a table (REF or ISA, depending). Then I realized...

[snip a bunch of stuff]

	dim MyDestConnREF
	set MyDestConnREF = CreateObject("ADODB.Connection")
	MyDestConnREF.Open = "Provider=SQLOLEDB.1;Data Source=TESLA;Initial Catalog=EDI;userid=sa'password=nothing"
	dim MyDestConnISA
	set MyDestConnISA = CreateObject("ADODB.Connection")
	MyDestConnISA.Open = "Provider=SQLOLEDB.1;Data Source=TESLA;Initial Catalog=EDI;userid=sa'password=nothing"

	select case ucase(trim(left(dtssource("Col001"),3)))
		case "REF"
			redim sArray(4)
			DTSDestination("recordnum") = recordnum
			DTSDestination("subrecordnum") = subrecordnum
			DTSDestination("type")	= sArray(0)
			DTSDestination("refnumqual") = sArray(1)
			DTSDestimation("refnum") = sArray(2)
			DTSDestination("description") = sArray(3)
			DTSDestimation("refid") = sArray(4)
		case "ISA"
			redim sArray(16)

Source: http://www.livejournal.com/community/sqlserver/26495.html

Date: 05/13/05 (Java Web)    Keywords: mysql, database, sql

Note: My WordPress database name is wordpress. I will use it in the example below. It will work for any MySQL database. (The procedure below will work with any version of WordPress too) Backup: mysqldump --opt wordpress | gzip -9 > wordpress.sql.gz Restore: gunzip wordpress.sql.gz mysql -u rootusername -p **** wordpress < wordpress.sql For detailed usage of mysqldump and mysql commands refer to [...]

Source: http://blog.taragana.com/index.php/archive/note-to-self-backup-restore-procedure-for-mysql-database-for-wordpress-etc/

Date: 05/18/05 (WebDesign)    Keywords: php, mysql, database, asp, sql

How difficult is it to learn PHP for use with a MySQL database? And how difficult is it to create the MySQL database? Like, would it take me months? I have no previous PHP experience...I've only ever done ASP.NET with VB.NET.

I'm going to be starting a new project at my summer internship, and I'm wondering if it's worth it to focus on this particular part of it (or if I need to just setup a prototype of how the data display will look, and tell them they need to find someone with PHP/MySQL experience to create the actual database and code).

Source: http://www.livejournal.com/community/webdesign/882497.html

Date: 05/18/05 (PHP Community)    Keywords: mysql, database, sql, web, google

This is driving me nuts.

I've got about a dozen different forms on my website that all have a date field of some sort, whether it be news date, dob, etc.  All of them are used to insert data into a mysql table.  I've got the corresponding fields in the table set as "DATE" fields.  But I'm having issues getting the date to convert properly.

Since the format of a mysql date field is YYYY-MM-DD, I have to do some converting in cases where I need to retrieve the date from the table.  For example, if I'm showing somebody's date of birth, I pull the info from the table and then use date() to convert the date to MM-DD-YYYY.  As in $dob = date("m-d-Y", strtotime($dob)); where $dob is the date pulled from the table.

The problem is changing that date and updating the table. When stuffing the date back into the table, I've gotta convert it back to YYYY-MM-DD, so then I use $dob = date("Y-m-d", strtotime($_POST["dob"]));

Works fine unless the date is entered on the form with / instead of - as a separator.  So what this leads me to discover is that on forms where the user enters the date, they could enter it any number of ways.  Even if I specify that they use dashes instead of slashes, there's no way to guarantee that they will.  That means that my date in the table will only be correct some of the time.

So what can I do to the date fields on all of my forms to ensure that no matter how the user enters the date, it will be converted properly to YYYY-MM-DD and stuffed into the table?

The best answer I could find on google was using dropdowns for month, day and year.  That would be fine on forms where the date is being entered for the first time.  But it would be a huge pain to implement on "edit" forms where the fields are populated from the database when the form loads.

I'm about to start pulling my hair out here, so hopefully somebody has a good idea.  I'm open to nearly any suggestion.

Source: http://www.livejournal.com/community/php/299442.html

Date: 05/18/05 (IT Professionals)    Keywords: programming, software, database, sql, web

Howdy all,

After 6 years in the trenches of application and network support I am calling it quits and returning to academia in social science. That is not to say that my IT days are entirely behind me. My area of research is going to be heavily reliant on Geographical Information systems and database design and analysis...

so I have a few questions for the group

1. (this one is an easy one probably).. I am looking to purchase a laptop in the next few weeks. I am torn between going with a tablet (the toshiba, I have seen far to many problems with some of the others , especially the acer) and a cheaper basic laptop. Essentially I am not all that concerned with performance if I go cheap. The first couple of years it just needs to run word processing, statistical analysis software, GIS software (on a low level) and that sort of thing. If I go cheap I would buy another one when i started the dissertation.. The question is on the reliability of the toshiba tablet.. have any of you used it extensively, or deployed them? I just want to be sure it is gonna hold up if I am gonna spend a nice chunk o change on it.. if the view is negative, whose laptops do you like? No way in hell I am getting a sony, but is there anyone else i should avoid like the plague?

2. For the SQL folks out there. It looks like the department uses MS SQL(I will have to stick with it for awhile because all the GIS programming courses are VB and i really won't have time to learn a real programming language). My question is, when I go to build my own SQL box what sort of spec should i be looking at? My databases will be the platform for my GIS mapping, and will be essentially legal databases with a relatively small amount of data (case name and number, disposition, appellate action, votes on appellate action and brief case summaries) Eventually it will all be set up with a read only web interface for sharing the data. How beefy am I going to need to go. I know MS SQL is a resource beast, so I probably can't get away with having it on a machine that does much else, but I am going to be on a grad student budget, so unless I get some major funding I will need to stay reasonably cheap

Input greatly appreciated!

Source: http://www.livejournal.com/community/itprofessionals/11926.html

Date: 05/18/05 (Web Development)    Keywords: php, database, asp, sql, web

I have an access database I'd like to put on the web, so:

1) Is the best way to do this using ASP? Currently the website is hosted on Dreamhost, which I don't think supports ASP. Is there maybe an easy way to export it to an SQL database and then use PHP?

2) If the best solution is ASP (which I've never touched), can you recommend any good hosts?

Thanks.

Source: http://www.livejournal.com/community/webdev/201019.html

Date: 05/20/05 (C Sharp)    Keywords: database, asp, security, web, microsoft

Hello All!
I need to have access to certificate services database from the c# web application. Approach described in msdn lib(http://msdn.microsoft.com/library/default.asp?url=/library/en-us/seccrypto/security/viewing_the_certificate_services_database.asp) does not seem to work. Or maybe i can't understand what the realy mean...
certadm.dll doesn't provide class implementation for IEnumCERTVIEWROW, IEnumCERTVIEWATTRIBUTE and IEnumCERTVIEWEXTENTION. Interface is an abstract entity as far as i know. (Unfortunately i don't know much...) So, how can one (as "ICertView::OpenView creates a IEnumCERTVIEWROW object") create an instance of an interface object with no corresponding class?
One version of my code looks something like this:

CERTADMINLib.IEnumCERTVIEWROW cvr;
CERTADMINLib.IEnumCERTVIEWATTRIBUTE cva;
CERTADMINLib.CCertViewClass CertView = new CERTADMINLib.CCertViewClass();
CertView.OpenConnection("pcitis31.cert.cern\\CERTSubCA");
CertView.SetTable(0);
CertView.SetResultColumnCount(-2);
cvr = CertView.OpenView();
cva = cvr.EnumCertViewAttribute(0); //-here i get COMException with 0x8000ffff code (Catastrophic failure)

Am i missing something, or am i absolutely on the wrong way?

Examples shown in msdn are quite similar(but in vb):

ex.1
' Declare the IEnumCERTVIEWROW object variable.
Dim objRow As IEnumCERTVIEWROW

' Instantiate the row object.
Set objRow = objView.OpenView

' Use the object as needed.
' When done processing, free the object.
Set objRow = Nothing

ex.2
' Initialize an IEnumCERTVIEWCOLUMN object.
Dim objCol As IEnumCERTVIEWCOLUMN
Set objCol = objRow.EnumCertViewColumn()
' Use objCol as needed.
' ...
' Free objCol when done.
Set objCol = Nothing

Any help, ideas are very much appreciated!

Thanks in advance!

Source: http://www.livejournal.com/community/csharp/29256.html

Date: 05/23/05 (MySQL Communtiy)    Keywords: php, mysql, database, sql

Hello! This is probably a painfully stupid question, but I'm asking anyway. I'm trying to select all records in the database where the start date (start, which is of type date, obviously) is between the user-supplied dates.

Entering select email from nexus where start between '2000-01-01' and '2005-05-01'; from the mysql prompt returns the correct information, but when I put it in a php script, it returns nothing. I've got other queries in this same script ("select email from nexus where ".$field." like '%".$term."%'") which are working as expected, so I'm pretty sure it's just that particular query.

It's probably something really stupid that I just don't see because I'm looking too hard, but I'm all out of ideas. If any of you kind folks have any insight, I'd really appreciate it. Thanks!

Source: http://www.livejournal.com/community/mysql/57350.html

Date: 05/23/05 (Java Web)    Keywords: php, database, java

Oracle integrates PHP scripting engine (dubbed "Zend Core for Oracle") with its 10g database and application server for building apps based on the open source development language. What remains to be seen is whether Oracle is shifting focus away from Java or just encompassing additional languages. So would .NET be the next? Oracle is joining several [...]

Source: http://blog.taragana.com/index.php/archive/oracle-aligns-itself-more-closely-with-php-developers/