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 (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/01/05 (PHP Community)    Keywords: mysql, sql

Code:

$TableNameADDR = "clients";

$Link = mysql_connect ($Host, $User, $Password);
$QueryADDR = "SELECT ClientFirst, ClientLast, PayorBillingAddress, PayorBillingAddress2, PayorBillingCity, PayorBillingState, PayorBillingZipCode, PayorBillingZipCodePlus4, InsCompany, InsAcctNum, service_notes, billing_notes, ClientRate, CGRate, dayrate from $TableNameADDR WHERE ClientID='$ClientID'";
$Result = mysql_db_query ($DBName, $QueryADDR, $Link);

if (!Result) {
print ("The Query could not be executed
\n");
echo 'Could not run query: ' . mysql_error() . "
$QueryADDR";
}

while ($ROW = mysql_fetch_array ($Result)) {

$CLIENTaddress2 = array_values($ROW);

$ClientRate = $ROW[ClientRate];
$CGRate = $ROW[CGRate];
$dayrate = $ROW[dayrate];

}//end while

mysql_close ($Link);

Why is the result for CLIENTaddress doubled? (every value is in the array twice). I verified its only going through the while loop once.

Array
(
    [0] => TEST DATA
    [1] => TEST DATA
    [2] => A_Curtis
    [3] => A_Curtis
    [4] => Market St
    [5] => Market St
    [6] => #321
    [7] => #321
    [8] => San Jose
    [9] => San Jose
    [10] => CA
    [11] => CA
    [12] => 95124
    [13] => 95124
    [14] => 3333
    [15] => 3333
    [16] => BandAid
    [17] => BandAid
    [18] => 1245
    [19] => 1245
    [20] => Testdata2
    [21] => Testdata2
    [22] => Testdata2
    [23] => Testdata2
    [24] => 40.00
    [25] => 40.00
    [26] => 20.00
    [27] => 20.00
    [28] => 
    [29] => 
)

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

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

So I have a strange problem. I have a table with a column that is day of the week as an integer. (0-6) Is there any good way to map those back onto actual day names (Sunday, Monday etc) in Mysql. Also is there a way to do this with season names?

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

Date: 05/03/05 (MySQL Communtiy)    Keywords: mysql, sql

Hi everyone,

I performed the following query to implement triggers. But error code 1064 occured.



create table distance(
edge_id varchar(20) NOT NULL,
source_node varchar(20),
dest_node varchar(20),
distance float(9,2),
parent_edge_id varchar(20),
road_condition int,
congestion1 int,
congestion2 int,
congestion3 int,
primary key(edge_id)
);


create table weight(
edge_id varchar(20) NOT NULL REFERENCES distance(edge_id),
weight1 float(9,2),
weight2 float(9,2),
weight3 float(9,2),
primary key(edge_id)
);


My Aim is to automatically insert rows into the weight table, upon insertion of any row in distance table.

So, I wrote the followin syntax:

create TRIGGER calculate
AFTER INSERT ON distance
INSERT INTO weight values(NEW.edge_id,NEW.congestion1,NEW.congestion2,NEW.congestion3);


Is the syntax correct for creating triggers? If it's not so, then please someone tell how to create triggers in MySQL...

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

Date: 05/10/05 (Web Development)    Keywords: asp, sql, microsoft

I'm looking for a good host that offers ALL of the following

Coldfusion
ASP.NET
Microsoft SQL Server

Does anyone have any good recommendations? Thanks :)

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

Date: 05/09/05 (Web Development)    Keywords: php, programming, mysql, sql

I need a script/app/whatever to just store credit card info, so they can be processed manually at a terminal later. What can I do about this? Any recommendations?

(I'm not a programmer myself and only have very basic knowledge of php/mysql so I'm hoping this won't need custom programming shit.)

Thanks a ton

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

Date: 05/09/05 (SQL Server)    Keywords: sql

...in SQL Server 2000.

I'm not sure what I want to do can actually be done, and my leafing through VBScript books/searching on the Internet has not brought me any closer to figuring it out. Hoping someone here may have an answer. (If there's a non-scripting solution, I'd certainly be open to that-- in fact, I'd prefer it.)

I'm reading in a text file. Each line of the file must go into one of a number of different tables based on certain criteria contained within the line itself. What I'm wondering is if there's a way to structure the data pump (or a different type of task) to read the line, look for the necessary criterion, and then shunt the line off into a table.

The way I'm doing it now has the text file going into a staging table, then parsing it from there. It seems to me that parsing the text file as it comes in would make for a pretty serious speed increase. As the package I have in place now takes approx. seven hours to run (and over half of that importing/parsing/getting stuff to tables), any increase in speed would be very welcome...

thanks.

Source: http://www.livejournal.com/community/sqlserver/26295.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/10/05 (MySQL Communtiy)    Keywords: mysql, sql

Does anyone have a mysql reporting tool that they like? A client of mine asked me about it and I’ve always used a homegrown one. We may continue to use my homegrown “reportmaker” but I thought it would be worth it to ask.

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

Date: 05/11/05 (Web Development)    Keywords: php, mysql, asp, sql, security, linux, microsoft, apache

I have to do a report my class Technical Writing. I have chosen to do a report on the LAMP Architecture vs. Microsoft Line of products. LAMP being Linux, Apache Server, MySQL, and PHP. Microsoft being Microsoft Windows, IIS Server, MS SQL Server, and ASP.NEt. What do you guys think is best? Are there any security flaws in one or the other? Which is more efficient altogether?
If you could help me with this, I would be very appreciative.

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

Date: 05/11/05 (MySQL Communtiy)    Keywords: mysql, sql

Hi everyone,

Am using MySQL 3.23.58... we have seen that it's possible to search any touple using the regular expression either using REGEXP or LIKE.

But i want to do something like searching by phonetics... like Spellchecking and closest word. Is there any method so that it can be done through SQL query only?

For Example:
Suppose if in a table 'items' the entry in 'item_name' field is 'COMPUTER' and if the searchable text is 'KOMPUTAR' then the syntax should find the table for the entry which pronounces like 'KOMPUTAR' and it should find 'COMPUTER'...

If there's not any SQL syntax then can it be done through REGEXP? if it's so then someone please give the REGEXP for this


Thank you.

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

Date: 05/11/05 (MySQL Communtiy)    Keywords: php, mysql, sql, web

I've got a typical weblog system setup, which allows users to comment upon posts.

The comments are located in their own table which has a structure similar to this (actually it stores thinks like IP address, etc too):

CREATE TABLE comments (
  id int(11) NOT NULL default '0',
  article int(11) NOT NULL default '0',
  parent int(11) NOT NULL default '0',
  title varchar(65) default NULL,
  author varchar(25) NOT NULL default '',
  body text,
  PRIMARY KEY  (id,article)
);

This is pretty standard stuff - the comments are associated with a particler "article", and they may also be replies to other comments - in which case the "parent" will point to the parent comment id.

This structure allows there to be a nice nested tree of comments, in which some are "top level" because they have no parent set, and others are nested.

One problem I'm having is that with this structure is that the naive implementation for showing the comments is using recursion - and this is slowing down significantly as the size of the comments grows.

The pseudocode looks something like this:

#  $article is the article these comments are associated with
#  $parent is the parent of the children we want to see
#  $level  is increased when we go deeper into the tree,
#          used to display a nice indented tree
sub display_children($article, $parent, $level) 
{
   # retrieve all children of $parent
   $result = mysql_query('SELECT * FROM comments WHERE article=$article AND parent= $parent') ;

   # display each child
   while ($row = mysql_fetch_array($result)) 
   {
       # indent and display the title of this child
       echo str_repeat('  ',$level).$row['title']."\n";

       # call this function again to display this
       # child's children
       display_children($article,$row['id'], $level+1);
   }
}

# Display comments for article 40:
display_children( 40, 0, 0 );

(This is a pretty faithful representation in PHP, but the actual code is Perl, using DBI).

So now onto the question:

How can I speed this up, and avoid the recursion?

I've looked at CPAN for DBI::Tree, and other obvious candidates but I see nothing suitable.

I think I probably need to change the structure into something more efficient to display, but I admit my SQL-fu is weak.

Any suggestions appreciated.

Source: http://www.livejournal.com/community/mysql/56692.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/14/05 (Code WTF)    Keywords: mysql, sql

[ru] писал выборку из БД по полу .. на автомате написал....
mysql_sex(); // и тут призадумался над аргументами....
[uk] писав виборку з БД по статті... на автоматі написав....
mysql_sex(); // і тут призадумався над аргументами....
[en] have wrote a select query, selecting a sex of user... but i have write not mysql_query, i have type mysql_sex(); // how do you think what arguments should be?

Source: http://www.livejournal.com/community/code_wtf/2990.html

Date: 05/16/05 (WebDesign)    Keywords: mysql, css, sql, web

So I know there has been MUCH talk about how CSS is the new standard to replace tables and such.. well I was struggling with learning exactly how it all played out.. until.. well I opened my eyes.. for all those Dreamweaver folks out there.. there are some prebuilt CSS page layouts that if you simply look them over, show you exactly how it's done and in good fashion as well.. so I'm now on my way to learning how to use CSS as the brains behind my web layouts from here on.. so there's my tip of the day.. now.. on to the topic at hand..

.. can anyone recommend a good DB Converter.. one such as Access to MySQL?..

Thanks in advance.

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

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