This particular query I am trying to do is using MySQL, but its probably the same with any relational database: Scenario: I have 20 tables, all...

globring@gmail.com

08-18-2006 12:27 PM
Bill Karwin

Dear Oracle Usenets, I am using Raptor to query an Oracle database. here is an example DB CODE Instances Day 100 ...

Novs

08-18-2006 11:42 AM
Jim Kennedy

Dear Oracle Sponge, I am using Raptor to query an Oracle database. here is an example DB CODE Instances Day 100 27...

Novs

08-18-2006 08:45 AM
Novs

Hi all, I am using Erwin Data Modeler 4.1.x. I want to explain a scenario. I have created a data model -> Created a database ffrom the data...

satishmullapudi84@gmail.com

08-17-2006 08:03 PM
ERwin

Does anyone know of a source for new database technology and uses? I've seen a lot of work going on around Web 2.0 applications,...

devm01@gmail.com

08-17-2006 02:23 PM
Michael Zedeler

We have a pretty straightforward Order, Customer, Products table setup. I'd like to figure out a query that would tell me which products tend to get...

lhenkel@gmail.com

08-16-2006 06:24 PM
lhenkel@gmail.com

Does anyone know how to produce some kind of report that maps the fields of one model alongside the corresponding fields of another associated model...

ren_111@hotmail.com

08-16-2006 12:03 AM
ren_111@hotmail.com

Warning to Access Developers about ACE. DON'T use multivalued fields (MVF) they are worse than LookUp fields and SubDatasheets, in fact they (MVFs)...

Craig Alexander Morrison

08-14-2006 07:40 AM
Craig Alexander Morrison

I everybody i need help to done a simple query that doesn't work. So i have a table where there are days of sale for many stores. Sometime in year...

Guillaume

08-13-2006 05:19 AM
Tonkuma

Hello, I would like to invite the open-source database community to submit presentations for the 2007 Southern California Linux Expo. We just...

Ilan Rabinovitch

08-12-2006 03:35 PM
Ilan Rabinovitch

Hello everyone I'm sure this is an old question, but I can't find a good explanation. I've read that many, but not all, SQL queries with a subselect...

Jeff Calico

08-12-2006 03:04 PM
Bill Karwin

Hi everybody there! I would like to implement a new lightweight database for my web applications, but relational model doesn't fit well my needs. I...

Claudio A. Andreoni

08-10-2006 12:52 PM
Dmitry Shuklin

Greetings. I was hoping someone could offer me some insight. I have a transaction DB with 300K unique transactions and about 50K unique customers....

AT

08-09-2006 02:40 PM
Michael Zedeler

hello new friends. I just completed two years of school for front end graphic and web design. I have a good job, and am happy, but am seeing lots of...

technorganic

08-09-2006 11:54 AM
AT

Hi folks, I've had to recently do my entire database over again because I majorly fudged up on a relation, rendering the db entirely useless. So, in...

Berti Ferranti

08-07-2006 08:49 PM
AT

Considering the following tables is it possible to write an SQL query that would result in rows that look like (EmpID, CourseID, DateTaken) for each...

rkc

08-07-2006 07:36 AM
David Cressey

I want to append a word to a TEXT field. so I use: UPDATE my_table SET my_text=concat(my_text,"a word") WHERE ... this statement will be repeated...

AT

08-06-2006 11:40 PM
AT

I am working on my PhD dissertation research and I need the assistance of an outside reviewer for my dissertation, who will work with...

AT

08-06-2006 01:46 PM
AT

I posted this question to comp.database.theory Perhaps this is a better venue. I've developed a technique that allows me to create a...

Rob

08-05-2006 09:26 PM
Todd

http://patft.uspto.gov/netacgi/nph-Parser?Sect1=PTO2&Sect2=HITOFF&p=1&u=%2Fnetahtml%2FPTO%2Fsearch-bool.html&r=1&f=G&l=50&co1=AND&d=PTXT&s1=7,069,308....

Mauricio Nivaldo Andres Monsalve Moreno

08-05-2006 08:40 AM
Kenneth Downs

Colorful t-shirts make a cool summer. We sell Pole/Bape/Locaste/BBC/Evisu /LV t-Shirts and so on,most worthwhile price.Delivery for free,5-7days you...

shoesleague

08-05-2006 01:03 AM
shoesleague

Stephen, I have done something similar where I work. The difficult part is putting the multiple databases together into one. What I did is I...

Jeff L

08-04-2006 05:33 PM
dataman

SHQL is an SQL database written in shell script. I have been using and expanding it and with the original authors permission I am making my changes...

Lorance Stinson

08-04-2006 12:47 PM
Lorance Stinson

I have a web site that has data valves (tubes to Americans) used in amateur radio. I have 370 data sheets in pdf format. But finding them currently...

Dave (from the UK)

08-02-2006 10:03 PM
Kenneth Downs

I hope that this is the right group for this basic question. Is there any existing software that can take data from my web forms and automatically...

Richard Crist

08-02-2006 04:47 PM
Richard Crist

I've been struggling with why I need one of these. All of Ralph's writings say the PK is the a composite of the dimension FK's. Well OK, but why...

dataman

08-02-2006 07:04 AM
David Cressey

We have what i think is a fairly run-of-the mill ledger table, with columns id, account_id and amount. In addition, we need a way to...

Isak Hansen

08-02-2006 05:55 AM
Isak Hansen

Hello all, Can you guys please recommend a good sql books which mainly concentrates on latest ansi standard. I do not want any vendor specific sql...

AT

07-30-2006 03:12 PM
Lee Fesperman

Howdy folks, *HJELP!* While experimenting with the a relationship problem , I think I might have fudged the database. I've set up a 1:1 relationship...

Berti Ferranti

07-30-2006 04:52 AM
Lee Fesperman

Could anyone help write an SQL statement to take this: Table X ( key, Money, TheDate, first, last, ...) = ( 1, $1, #jan 4, 2006#, 'fred',...

Nathan Moore

07-29-2006 05:15 AM
nategoose (AT) gmail (DOT) com

Probably not a great idea, but is it possible to create a constraint on an aggregate of rows? E.g. "sum(amount) = 0 group by foreign_key" Any...

Isak Hansen

07-28-2006 06:19 AM
Isak Hansen

Ed Prochak wrote: Right. My point is, I can have it better _for the purpose_. Well, not exactly true. While you can't add dimensions (iow...

Dmitry Shuklin

07-27-2006 03:57 PM
Ed Prochak

Hello! I use Visual C++ 2005 Express Edition and mysql++2.1.1. Everythink works fine when I'm useing object...

AT

07-27-2006 04:57 AM
AT

hey all... im looking to set up a p.o.s system in my shop, it's a grocery store. After receiving quotations from three sources, they all spoke...

AT

07-26-2006 06:56 AM
AT

Oracle JDBC driver has been called classes12.zip. Is there any way that I can check what Oracle database version comes with the classes12.zip that I...

lovingmononoke (AT) gmail (DOT) com

07-24-2006 06:59 PM
lovingmononoke (AT) gmail (DOT) com

I have an old database app that is no longer supported. It stored data in tables in individual files. Associated with each file is a .key file. Is...

AT

07-23-2006 06:13 AM
David Cressey

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