Hi, I have a database with two tables a) A table of 2 million records with city, zip and associated information (say XYZ) and b) zipcode latitude,...

AT

07-23-2006 05:06 AM
AT

Hello, Secure Data Software is announcing that our GPL'd database-centric PHP framework has gone into...

Kenneth Downs

07-21-2006 12:20 PM
Kenneth Downs

Hello all, I am getting started with relational databases and have been playing around with MySQL and SQLite3. A problem I find common between the...

AT

07-21-2006 12:14 PM
Kenneth Downs

I was hoping someone could guide me to a database comparison site or alternatively share their knowledge with me. I am currently using Access but...

AT

07-21-2006 10:55 AM
David Segall

Hello out there! I have a client that has old legacy apps written in FoxPro 2.5 for DOS running under Windows XP. A lot of the screens...

Guardsman

07-19-2006 10:19 PM
Kenneth Downs

Hi All How do I set the lock timeout in MySQL if at all possible for the time that should be spent in obtaining a row level lock ? Also is there a...

AT

07-19-2006 01:57 AM
AT

Hi How can I extract time value from a date column in oracle. For example, I have a date column which stores date as 7/6/2006 1:21:00 PM. I want...

pankyrai

07-18-2006 09:29 PM
Jim Kennedy

Hi all! Is there anything like Hibernate but for C++? Thank you in advance! Alessandro

AT

07-18-2006 06:05 PM
Michael Zedeler

Hi I have a date column in one of the table in oracle. The date value stored is: 7/5/2006 2:11:00 PM. I would like time to be updated to 6PM so...

pankyrai

07-18-2006 06:05 PM
Michael Zedeler

Hi, Assume I have a table with only 1 row and all column is 'int'. I just wonder is it possible to use SQL to check if any one of those...

AT

07-18-2006 01:44 PM
Al Balmer

Hello, I'm trying to determine the negation of A intersect B quicker than: (A UNION B) MINUS (A INTERSECT B) Is there a standard SQL operator that...

AT

07-18-2006 01:30 PM
AT

howdy, Nested sets (or modified preorder tree transversal algorithm) work great if a specific node only exists once inside the tree. I am using my...

bernie

07-15-2006 04:47 PM
lennart (AT) kommunicera (DOT) umea.se

Hi guys, This might be simplest thing, but I am newbie to databases. I need to find out only rows modified within certain time period from...

AT

07-15-2006 03:22 AM
metaperl

I need to produce a data model diagram with attribute names for the following scenario which include cardinalities in the diagram. Richard's...

AT

07-12-2006 12:20 AM
Last Boy Scout

I have a problem with a MySQL query, that I have been trapped with for 3 days now. I just don't get it, as I think the result is inconsistent. I am...

JD

07-11-2006 02:28 PM
Gene Wirchenko

hello, from one part I have MySql 5.1 from one other part SQLite the request...

Thierry

07-11-2006 05:59 AM
Thierry

SQLeonardo a powerful and easy-to-use tool that lets you query databases. Visual query-builder restyled Download the latest release at...

Staff

07-10-2006 04:35 PM
Staff

Hi there, I'm newbie with a newbie question: To deal with Bioinformatics data, such as sequence data, protein data, or network biology data, which...

CC

07-05-2006 04:16 PM
Dmitry Shuklin

Can anyone recommend any books on data quality not necessarily specific to data warehousing?

Niraj Agarwalla

07-05-2006 03:54 PM
Paul

Hi ! I occasionnaly design some database, both for my work or personnal projects. I've read here and there that it's not a good design to use OIDs....

rixed

07-03-2006 12:51 PM
Ed Prochak

Hello everyone. My problem is I want to make a query that will produce table that look like crosstab report. My table is tblTransaction with field...

Lemune

07-03-2006 03:12 AM
Dieter Noeth

This week I came across the same construct the second time, and I am curious whether it is good practice or not. A huge table was factored according...

AT

07-02-2006 01:23 PM
David Cressey

Hello, I have been working with an MS Access database for a couple of weeks opening and closing it several times a day. This morning when I...

Mel

07-02-2006 01:15 PM
David Cressey

AppStream enables IT Organizations to automate their deployment of software applications allowing software to be centrally managed and available...

Cherie Mealie

06-30-2006 06:01 PM
Cherie Mealie

Hi, My problem is one of application design. I have some objects in my application which map to tables in database. I used C# and mssql but that's...

doina babu

06-30-2006 11:13 AM
wem

I am a newly indoctrinated SQL Server 2005 user. So, forgive me if this question is amatuer. I am trying to create a stored proc that will read in a...

rbr

06-30-2006 07:59 AM
SRV

Hi all! I have to deal with several dBASE-Files. Does anyone know a program that provides an SQL interface to dBASE databases without converting...

Roland Spielhofer

06-30-2006 03:41 AM
David Segall

The book "SQL Queries for Mere Mortals" says to prepend the table name to all of your columns. Other books might say prepend the table name to the...

metaperl

06-29-2006 09:11 AM
David Segall

Hi, I have two tables like these: (this is an example, the actual tables have diffferent fields and...

filippo

06-28-2006 08:00 PM
Last Boy Scout

Hi everybody, I've been mulling over the possibility of writing a universal DB command line interface program. The finished product would function...

AT

06-28-2006 09:47 AM
--CELKO--

Hi, I need to put together teaching materials for a certain subject on which I am an expert. I'd like an interface similar to video professor, where...

AT

06-27-2006 02:33 PM
Ed Prochak

Hello all. I'm fairly new to Universe and am still learning some basic commands. Can someone please tell me how I can do a search for certain records...

AT

06-26-2006 03:24 AM
Kreegor

i'm starting a wiki on coding, keeping everything seperate. anyone who wants to help check out the site. i want to document every function for every...

da404LewZer

06-22-2006 01:31 PM
da404LewZer

Hi, I'm ADEL How can I use the Leader Field in a new database on CDS/ISIS? Thank you for your attention! ADEL

ADEL

06-21-2006 03:13 PM
ADEL

Hi, I'm helping a friend to build a system to handle advertisments from local dealers in different regions/cities. In this system, an advertisment...

AT

06-20-2006 11:36 PM
--CELKO--

In a fabulous book -- "Practical Issues in Database Management" -- the fabulous author, Pascal Fabian, lists three reasons for choosing one candidate...

AT

06-20-2006 03:54 AM
Michael Zedeler

Hi, What do you feel on the comparison between these 2? Any outline on the pro's & con's? Nowadays, we have free versions of proprietary databases...

Raga

06-19-2006 07:35 AM
Gints Plivna

Hi, Is it possible to get the list of all the macros in a approach application in to a text or excel file? cheers, Nuti

Nuti

06-19-2006 02:29 AM
Nuti

I've decided I need to first document business rules for a project I'm working so I can design and build a more robust and hopefully extensible and...

AT

06-16-2006 02:30 PM
--CELKO--

================================================================== Call for Papers ICDM '06: The 6th IEEE International Conference on Data...

wi-iat

06-16-2006 03:46 AM
wi-iat

XML 2006 -December 5-7 - Boston, MA The Call for Papers for XML 2006 is now open. To submit a proposal visit:...

melledge

06-15-2006 10:51 AM
melledge

Julien Lafaye wrote: Why not put random data in it, if it's only for scalability tests. I assume that the contents of the data is not important, so...

wem

06-15-2006 05:59 AM
wem

Hello, all: I am pleased to announce that the MySQL Journal is moving forward.*During the past two weeks, I've been discussing the journal with...

Sam Flywheel

06-14-2006 07:29 AM
Sam Flywheel

In mysql 5.1, you can this: select a.*, b.title as btitle from tablename a inner join tablename b on a.bid = b.id; but what I want to do is make a...

AT

06-13-2006 01:10 PM
Bill Karwin

Hi Everyone, Stylus Studio 2006 Release 3 is now available. The release includes new XML tools, enhancements to Stylus Studio XML Deployment...

Stylus Studio

06-13-2006 10:59 AM
Stylus Studio

Hi, I have two tables: the first one has all details about persons, the second associate the id of each person to the id of his team...

AT

06-12-2006 05:24 PM
Lennart

Hi! I'd like to know if it's possible to use Google APIs to make a text search into DBs such Oracle or Sql Server. Thanks!

AT

06-11-2006 07:45 AM
David Portas

Hi All, I would be tempted to think that an Invoice (once finalized, sent to the client) should stay immutable. For example, I don't think that data...

Dae.OS

06-10-2006 09:23 AM
Dae.OS

Hi, I am looking for a roommate for SIGMOD '06. I've reserved a room at the Renaissance hotel for June 26-28. If interested, contact me at navendu...

AT

06-09-2006 08:11 PM
AT

Hi All, Current we have below tables update scenario: There are 2 tables example1_tbl and example2_tbl. When customers update example1_tbl, we want...

Franklin Li

06-09-2006 05:11 AM
Michael Zedeler