Date: 02/23/05 (WebDesign)    Keywords: browser, database, java, web

Lo,

I've a great big table and I'd like users to be able to easily search it. Normally I'd produce this with a database backend and just do a search function with that. That's not an option this time. Instead I was simply aiming to use JavaScript to open up the web browser's find feature. That's Ctrl+F on Internet Explorer, etc.

I've had no luck though. Anyone know (if it's possible) the JavaScript to open the find/search box in the web browser. Anyone have any suggestions for a client side search function? (Just one static page.)

advTHANKSance.

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

Date: 09/24/04 (Web Hosts)    Keywords: database, sql, spam

I upgraded my primary mail server to SpamAssassin 3.0.0 last night. So far so good, it has a full updated ruleset to catch more spam. I noticed 2.5.x was starting to let a lot slip through the cracks. It also has modules to store auto white listing and bayes in an sql database now which is sweet. So i have awl, bayes, and custom user preferences all stored in the sql database. So far its catching WAY more spam than the old version.


Release Notes

SpamAssassin


:)

Source: http://www.livejournal.com/community/webhosts/19464.html

Date: 09/11/04 (Web Hosts)    Keywords: mysql, database, sql, linux

Just curious on what you guys use to host your sites. Pros/cons? Specs? Like myself:

Site: Frankly Jason
Host: Cyberpixels.com
Specs: 9.95/mo for 400 MBs, 15 GBs bandwidth, and uber amount of pop 3 emails, ftp accounts, sub-domains and mysql databases
Server OS: RedHat Linux
Control Panel: cPanel

Pros/cons: Everything runs pretty smoothly except the lag time on uploading to the FTP. Uploading is fast, just the connection with the ftp as each file goes onto the space.

Source: http://www.livejournal.com/community/webhosts/19341.html

Date: 02/22/05 (SQL Server)    Keywords: database, asp, sql

I have this really obnoxious scenario where I need to take the table structure from one of my SQL Server 2000 databases, and copy all of the tables down to a new MS Access database. There's a LARGE NUMBER of tables, so recreating each table in Access manually should be a last resort.

I've looked into using the DTS wizard, but when Exporting Data, I cannot simply execute the "CREATE TABLE" statements without copying the data it seems? That, or if I modify the DTS package by hand afterwards, DTS sets up each table as a separate command stream, so I have to manually modify each to rip out the data transfer portion. This is extremely irksome.

Then I speculated on generating the "CREATE TABLE" T-SQL via SQL Server and running that against the Access db. Not being terribly familiar with Access, I'm unaware of any actual SQL front-end. But from my 'net application dev days, I have an old ASP page which I'd use on remote servers to modify client Access dbs that I otherwise didn't have access to. So thought of using that as my front-end, but then realized that the T-SQL generated code would NOT be Access friendly due to differing datatypes!

So I'm growing rather irritated with this situation and thought I'd ask folks out here for advice on this? Any ideas would be greatly appreciated!

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

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

Hey, does anyone know how to set up a SQL Profiler Trace to log reads/writes to a specific database object? I tried reporting on object name, but so far all I can get to show up is Locks on ObjectName and the object name shows up blank. Any ideas?

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

Date: 12/23/04 (SQL Server)    Keywords: mysql, database, sql, postgresql

cross-posted to databases

For privacy protection within an application, I hash email addresses into MD5. MySQL, PostgreSQL, and Oracle all have a scalar function that allows you to hash a column/string -- for example MD5(emailaddr).

I have yet to find such a function, or a handy library/package for creating such a function in SQL Server 2000. Did I miss something? recommendations?

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

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

hi all

i have a webservice that returns multiple datasets of different tables that i need to merge/sync with a destination database that is accessible through a middle tier component that i wrote. unfortunately, i'm restricted to the use of ado.net and datasets due to the nature of the webservice in question. i'm working with moderately high number of records (largest table is around 5k rows) that i need to insert into the destination database, and i'm using the dataset.merge method with a customized insertcommand (as i need to wrap identity insert on around it and also the table columns won't be determined till run time) passed to the dataset, and it's pretty slow. i think part of the slowness comes from having to figure out the column schema of the varying tables, and also the fact that ado.net is not particularly a useful tool for data transfer. just wanted to know if anyone has any pointers/ideas as to how to optimize this routine? thanks in advance for your input.

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

Date: 03/06/05 (Java Web)    Keywords: database, sql

I have noticed that despite closing all connections and exiting a standalone HSQLDB database, at least one connection still remains open. The defect is manifested in HSQLDB 1.7.3 and HSQLDB 1.8.0 RC 8. If you compile and run the sample code below, it will run fine for the first time. Second time (if it is run [...]

Source: http://blog.taragana.com/index.php/archive/how-to-close-all-connections-in-hsqldb-to-prevent-a-locking-defect/

Date: 03/09/05 (Computer Geeks)    Keywords: database, web, linux

Hi all,

I'm the new network admin for a boarding school. They were without an IT person for a while and as a result have almost zero infrastructure. I'm wanting to build things up the right way so I don't have to tear stuff down later.

Anyway, we have a lot of different clients. Mostly Windows and Macs, but some Linux boxes as well. I don't have much experience with multi-platform environments. What is the best choice for directory authentication? How much of a pain is it to get Macs and Linux to authenticate off of Active Directory? How much of a pain is it to get WinXP to authenticate off of OpenLDAP or NIS? We aren't doing anything terribly fancy. Basic file and print sharing, a couple of databases, etc. the school has its email hosted outside, but I'd like to bring that inside eventually. We have one Win server, 2 Mac servers, and a handful of Debian servers, though all of this is subject to change. The network isn't providing much in the way of services, just your basic web access, DHCP, DNS, etc.

I realize this is a relatively open question, but any discussion and advice would be great. Thanks.

Source: http://www.livejournal.com/community/computergeeks/627593.html

Date: 03/10/05 (IT Professionals)    Keywords: database, sql

OK, I am not an AD specialist, far from it.  However, it is falling to me to do some user creation and maintenance as I have the ability to script from the SQL database and perform mass operations.

I have been looking for an answer to this for a bit and cannot find any info that explains the behavior that I am seeing.

When I add accounts with a DSADD command, the displaynam shows as the logon name and not the value I specify in the -display attribute.  The Display Name field is populated and shows up corectly, both in the GUI and with DSGET USER [name] -display.

I can right click in the MMC and rename the user, but that defeats the automation a bit.

Is there something I am missing?

Thanks in advance.

X-Posted: computergeeks and itprofessionals

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

Date: 03/11/05 (PHP Community)    Keywords: php, mysql, database, sql

I have a base class in which I'd like to extend. The thing is, the base class connects to a database. How can I make it so any classes I extend from base class will share the one connection to the database and not make a duplicate connection for each object i make?

example:

class base {
 var $connection;
 function base(){
  $this->connection = mysql_connection("server","user","password");
  mysql_select_db("database",$this->connection);
 }
 function exec($query){
  return mysql_query($query,$this->connection);
 }
}

class child extends base {
 var $foo;
 var $bar;
 function child(){
  $this->foo = mysql_result($this->exec("select foo from foobar"),0);
 }
}

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

Date: 03/14/05 (Computer Geeks)    Keywords: database, sql

Well, no.

I'm actually interested in hearing your definitions or seeing good examples of SQL. I'm a bit uncertain of what it is. The best I could do is, "SQL is a database creation and modification program."

Think you could toss me a bone, here?

Source: http://www.livejournal.com/community/computergeeks/634697.html

Date: 03/14/05 (SQL Server)    Keywords: database, asp

A procedure I wrote that doesn't work..

create proc cal(@days as int, @num as real output) as
BEGIN
DECLARE @h int, @l int, @r int, @a int, @b int, @c int, @blah real
set @h=(select sum(heritage) from loctab);
set @l=(select sum(leisure) from loctab);
set @r=(select sum(religion) from loctab);
set @a=(select heritage from loctab where locid='vzg');
set @b=(select leisure from loctab where locid='vzg');
set @c=(select religion from loctab where locid='vzg');

set @blah=((@a+@b+@c)/(@h+@l+@r))*@days;
set @num=@blah
return @num
END

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

Date: 03/15/05 (Web Development)    Keywords: php, mysql, html, database, sql, java, web

This is long so a cut tag...

So recently I’ve been working on some new stuff. In recent versions of Mozilla (including Firefox) there is now a SOAP client. This means that a web application can access the server at any time, and not just when the page loads. This means a huge amount of flexibility is now available to the developer in a DHTML application. I have been playing with this for several months and realized that a large amount of the code is very repetitive.

I am working on a application to build these applications. I have a DHTML page which lets you model your application. It pulls table and index definitions from a MySQL database, and then it lets you set up validation rules for each field, set up custom SQL queries (In addition to a number of automatically generated ones), set field labels, and change other things about the data model.




So far I can auto generate
* DHTML Forms
* Javascript glue for the forms
* Javascript to wrap the soap functions into simple javascript methods.
* PHP classes to access a mysql database
* A wrapper to serve the PHP classes up as SOAP.

Still to do

* Data validation
* Unit test frameworks
* Installer scripts for a generated application

For more information see my wiki
I plan to have the code on source forge (project “xulbuilder”) today or tomorrow

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

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

I'm working on a database table and am having trouble getting the dates added properly. I want two date fields, one to store the date the record was created, the other to store the date it was last modified. However, I can't figure out how to get the fields to hold anything but a bunch of zeros. I've tried TIMESTAMP and DATETIME and using the PHP time function and reading through the mysql.com documentation and am still in the dark. Any help would be appreciated.

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

Date: 03/16/05 (Open Source)    Keywords: database, linux, google

Upgrade a network application and it propagates immediately to all users. In many ways that s all Google is, a networked Linux application (database-driven). They ve been very busy taking new features gold lately: Google Maps. (Slow loading, but attractive.) Google News. (Input your own keywords and dump their categories ...

Source: http://blogs.zdnet.com/open-source/index.php?p=190&part=rss&tag=feed&subj=zdblog

Date: 03/16/05 (PHP Community)    Keywords: php, mysql, database, sql

I have a timestamp in my MySQL database. I grab the information along with the other table information using a select, then want to display it in my PHP pages. However, everything I've tried turns up really funny displays. Is there a way in PHP to format MySQL timestamps?

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

Date: 03/16/05 (PHP Community)    Keywords: database

I want my code to display a search not found message when a search is returned null from the database, why isn't this working?

Right click save as...

The Code

Sorry about the original post.

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

Date: 03/17/05 (PHP Community)    Keywords: php, mysql, browser, database, sql, web

Hi, thanks in advance for any advice.

I am working on a website on my PC, and I don't know anything about servers but I wanted to develop locally, so I am using a WAMP package. I would like the site to be able to display database entries from mysql that are in Japanese, but when I call them I just see question marks instead of the Japanese (using various browsers and encoding options). I can, however, just echo Japanese text in the php file and it will display properly. Also, in phpmyadmin where I am creating the database the Japanese is displaying correctly.

I don't know if it's a problem with the server, mysql, or the script, so I don't even know where to start. I have tried it with the db, table and fields collated in both sjis_japanese_ci and utf8_unicode_ci, with the same results.

Does anyone know what the problem could be? Thanks!

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

Date: 03/17/05 (PHP Community)    Keywords: database, sql, postgresql

I'm trying to connect to a PostgreSQL database on a system that only allows unix socket connections. The DNS I'm trying is below, but no joy so far. I've verified that I can connect to the database on the commandline with 'psql'.

$db = DB::connect('pgsql://username:password@unix(/tmp/.s.PGSQL.5432)/database');

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