To access the Unix database from NT, there is a good tool I use called
webmin (http://www.webmin.com/). It is written in perl and uses a http
connection through a different port. I don't know about connecting to NT
from Unix, I only have databases on Linux.
len.
-Original Message-
Petra,
You have a close '}' with no open '{'. Maybe you should move the If
statement to the next line, then it won't be commented out.
len.
-Original Message-
From: Petra [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, 27 March 2001 13:21
To: [EMAIL PROTECTED]
Subject: parse error
You can use the 'limit' construct on the end of the select statement.
So for first query do
select blah from blah where blah limit 20;
each succeeding query will be
select blah from blah where blah limit 20,20;
check the doco for explanation.
You can do a count to start with to determine
Hi, I was wondering if anyone could help me with some SQL. I have a product
group table that has a link to itself to allow me to build a hierarchy of
products. Each Product has a link/relationship to its parent, so I have
PRODUCT GROUP
PRDGRP_TK Primary Key
just won't work in this
case.
-Original Message-
From: Eric Fitzgerald [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, 14 March 2001 10:59
To: Leonard Coonan; [EMAIL PROTECTED]
Subject: Re: Unary Relationship.
Very situational
Let me lay out what I *think* your saying your, tell me i
Further to your comment, I have had considerable benefits by creating an
index of both keys as well. So I define 3 indexes userid, usernum,
useridusernum.
hope this helps.
len
-Original Message-
From: Dan Nelson [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, 14 March 2001 16:06
To: Bob
