Good day mates, I'm trying to build a database to keep track of information that will be stored when my client kicks off his brand new Taxi Cab...

Knowledge

06-30-2007 09:49 PM
Knowledge

How to achieve tree structure in MSSQL I have two tables as follows. I need a hierarchical structure Test category id Demo ...

Nitin

06-30-2007 06:33 PM
Tonkuma

Hi All, I have a table and each row is a company - the name of the company, the website, etc. What I would like is one of the entries to be a...

Rick Giuly

06-30-2007 07:01 AM
Rick Giuly

Hi all I have a problem and I cannot solve it. I want to divide a long page in pages, I know how to do it if I use recordset (ADODB). But if I have...

LaiLakY

06-27-2007 04:49 AM
LaiLakY

Hello, I get pages of error logs with this message - "Got an error reading communication packets". And the aborted clients are easily in...

narmathabala@gmail.com

06-26-2007 11:28 AM
Tonkuma

Jordan Marr <jnmarr (AT) hotmail (DOT) com> writes: I decided to try this, as an SQL exercise. I took me a couple of hours to get right, and I'm...

Mark Jeffcoat

06-25-2007 03:33 PM
Jordan

I'm considering purchasing DataBase Professional and converting my datasbases from Approach97 to DBP. The cost of getting the latest Approach, given...

Frank Van De Warker

06-21-2007 07:56 PM
Frank Van De Warker

Hi, I'm looking for two books: Oracle8i DBA Handbook Kevin Loney, Marlene Theriault Oracle9i DBA Handbook Kevin Loney, Marlene Theriault Could...

Dlugi

06-20-2007 10:26 AM
Tonkuma

Hi, I am looking for a downloadable oracle data profiling/quality tool. Any recommendation is highly appreciated. Thanks a lot!

goog

06-20-2007 08:27 AM
Ed Prochak

hi is there any dbms (relational) which is available for free & for windows/linux. my other constraints is that the dbms should support sql-99 & it...

punit arya

06-15-2007 07:43 AM
Lew

In article <466f16f2$0$90276$14726298 (AT) news (DOT) sunsite.dk>, Nis Jørgensen <nis (AT) superlativ (DOT) dk> wrote: Yes it does. Thank you very...

Steven Paul

06-15-2007 12:43 AM
--CELKO--

I am interested in informed feedback on the use of Constraints, Primary Keys and Unique. The following SQL statement creates a Bands tables for a...

Peter

06-14-2007 06:52 PM
Lew

In January, I announced our TPoX benchmark that became public on tpox.sourceforge.net. We just had its next release. What is new? (1) TPoX 1.1...

ikogan@ca.ibm.com

06-13-2007 08:41 PM
ikogan@ca.ibm.com

Say I have a table with three columns - description, parent_id, and id. Each parent_id can, itself, point to another id with a parent_id. It...

yawnmoth

06-13-2007 11:29 AM
--CELKO--

Hi everybody, I am interesting in some tutorial or introductory paper on fuzzy logic for databases. Not an expert in fuzzy logic, so it should...

418928@cepsz.unizar.es

06-11-2007 03:05 PM
418928@cepsz.unizar.es

SQLeonardo a powerful and easy-to-use tool that lets you query databases. Download the latest release at http://sqleonardo.altervista.org

nickyb

06-08-2007 05:40 PM
nickyb

Suppose I want a column in my table to reference two other columns of other two tables (of course datatypes are same, and the other two columns are...

Ravi

06-08-2007 08:42 AM
punit arya

Help! I am trying to write an SQL statement (without much luck) to extract the total number of searches and orders from a particular...

whitsey

06-05-2007 12:05 AM
zahid4848@gmail.com

Dear All I am planning to work on a semantic web project (with Jena) using a database as backend. Appreciate your tips on which of these is the...

Evrim

06-03-2007 04:47 PM
Lew

Hi All, Due to environment constraints, I have to be able to connect to the local mysql port (3306) via the hostname "localhost". However, using...

Stephan Carydakis

06-03-2007 04:45 PM
Lew

I'm making a small training program, and I have various exercises such as: biking, strength training etc. Some of the fields for these...

koger

06-03-2007 07:50 AM
Lennart

Hello, Our developers use UML and make class diagrams (A). Our DBA team wants to make physical diagrams with powerdesigner (B). - create a data...

zejeanmi@gmail.com

06-01-2007 02:14 PM
Alfredo Novoa

We are a high school establishing a new database system, for donors, PTA, and alumni. In doing a needs assessment, I have a problem: we are just...

dapez

05-31-2007 10:01 PM
David Cressey

On May 25, 10:38 am, Nis Jørgensen <n... (AT) superlativ (DOT) dk> wrote: Why don't you take a look at it? 3.23/4.0/4.1 are documented in one lump...

jag

05-30-2007 01:48 AM
Bill Karwin

Copies of my book "Analytics & OLAP in SQL" have pages 13-44 missing and pages 61-92 printed twice. Please contact Morgan-Kaufmann or your book...

--CELKO--

05-29-2007 02:12 PM
--CELKO--

Hi I'm looking for examples of an Employee data model that touches on concepts of Employee status, position, title, department, division, section,...

Shayne

05-28-2007 11:03 AM
David Cressey

Hi All, Just try the link below to have a look at the informative and basic key points of...

William

05-28-2007 04:59 AM
William

At work I used SAS and FoxPro and liked them both very much. I had the opportunity to sit in at a course in DB2, but when I asked how to set up a...

Heinz Schmitz

05-25-2007 12:10 PM
Gene Wirchenko

I'm looking for a algorithm which checks if a nested set with many nodes and levels is correct. I know the pear class and I have read a few...

alexander.buze@googlemail.com

05-25-2007 09:01 AM
--CELKO--

The IUA is delighted to invite you to the free to attend, one-day Ingres Users Association Spring Conference on Wednesday 6th June at De Vere Holborn...

Roy Hann

05-25-2007 04:33 AM
Roy Hann

hi, i need to write simple c program that work with MYSQLAPI .it's very simple to do, i have just made test with connection and retrieve result, but...

F4bi0

05-25-2007 04:23 AM
F4bi0

Hy First sorry for my terreble english. How do i remove first 3 words in field "post". I nead to remove first 3 words i all the records. In every new...

Master_Di

05-22-2007 02:14 PM
Master_Di

Hi folks! Usually I use oracle 9i but this time i need to find a simple, freeware tool which has a possibility to draw ERD diagrams ( I dont care...

Snake Plissken

05-22-2007 06:57 AM
Snake Plissken

Dear comp.databases, Stylus Studio 2007 Release 2, is now available for free trial download or online purchase. Here are some of highlights: *...

stylusstudio@gmail.com

05-21-2007 03:36 PM
stylusstudio@gmail.com

Hi, I'd like to log some data to a log file (could be any format), the goal to make the entry unique (for example, each entry in the file have an...

Leeh

05-21-2007 03:32 PM
Ed Prochak

JOB ID: BE 1901 - Please refer to the Job ID in all your communication both in subject line of your email and in the body text. Hi Friends, hoep you...

Imran

05-21-2007 12:36 AM
Imran

Hi all, I am trying to get a portable SQL statement that returns the difference between 2 dates as a number of seconds. Is there any possibility to...

johan.de.taeye@gmail.com

05-18-2007 03:22 AM
Lee Fesperman

if I have two databases, is possible to limit the access of one user only at the own db and to avoid, for example, if it use a sql injection can...

artev

05-17-2007 03:02 PM
artev

se si hanno due database, è possibile limitare l'accesso di un user solo al proprio ed evitare che ad esempio se usa sql injection dal suo db possa...

artev

05-17-2007 02:46 PM
artev

Razvan Socol wrote: Thinking you might get a better response from comp.databases, I am cross-posting your question there.

Bob Badour

05-17-2007 02:10 PM
Lee Fesperman

Hi I am working on a paper about : how different indexing techniques work as dimensionality increases? I could not find much ideas on the net....

ErkanY

05-15-2007 11:38 PM
Last Boy Scout

Hi, I hope some experts can shed some light on this. I have a table that is very INSERT-heavy. Most of the days, it only needs to accept data,...

L. Berger

05-15-2007 01:45 PM
Ed Prochak

Hi all! I am trying to create an database for relation between parents and their children. I started with these Entities: Parent Child Parent_Child...

dnomade@gmail.com

05-14-2007 10:24 PM
Last Boy Scout

*Job ID: JK 1101* *Please refer the Job ID in all your communication, both in subject line of your email and in the body text.* Hi Friends , hope...

Imran

05-14-2007 10:03 PM
Last Boy Scout

Hello! I am developing a database system that will allow users to store any object whatsoever in a database. Usually a database has predefined...

herbasher

05-14-2007 05:49 AM
Gints Plivna

I use MySql and need to have a diagram showing how the tables and their fields and how the tables are related. Till now I have generated the tables...

damezumari

05-13-2007 07:17 AM
damezumari

Hi, Hope everyone is doing great! I am thinking about modify the algorithm to secretary problem and apply it to get airline purchase. Also, I know...

Sarah

05-12-2007 08:03 PM
--CELKO--

I am looking for tools that automate, or help , the conversion of Oracle's PRO*C to Oracle PL/SQL.Information on any such tools and experiences are...

Selvarengan@gmail.com

05-11-2007 01:41 PM
Ed Prochak

Is there a generic way, using ODBC/OLEDB/ADO.NET or another programmable database technology to determine foreign and primary key constraints in a...

Jason D.

05-10-2007 12:00 PM
Sualeh Fatehi

Hi, I want to calculate the fraction of two counts and I have created the following select statement: select field1, field2, (select...

Niels Dybdahl

05-08-2007 08:36 AM
Tonkuma