Title: Something completely different
I'm
currently working on something very similar. We have a national database of zip
code information provided by USPS. each table in our db is prefixed with the
first three digits of a given zip code. ex. (190_zip, 191_zip, 192_zip,
etc) each table has
On 25 Mar 2004 at 16:03, John Newsom wrote:
> Thanks, Bill. I now see my problem. I was trying to count the number of
> times a particular student id occurred (namely, once for each order). My
> approach should have been to count the number of order ID's for each
> student ID. It's funny, but b
Thanks, Bill. I now see my problem. I was trying to count the number
of times a particular student id occurred (namely, once for each order).
My approach should have been to count the number of order ID's for each
student ID. It's funny, but both approaches actually work, but the
Witango search
srini,
"Srinivasan" <[EMAIL PROTECTED]> wrote on 26/03/2004 09:30:46
AM:
> Hi Russell,
> Thanks for your reply...
> I have already done modifications and made it to display that OCI is
getting
> initialised (message on events log). However whenever I try to establish
a
> connectivity to the
Hi Russell,
Thanks for your reply...
I have already done modifications and made it to display that OCI is getting
initialised (message on events log). However whenever I try to establish a
connectivity to the database it crashes with Fatal error. Any idea on this
issue?
Srini
-Original Me
srini,
i think you need to have the OCILIBPATH set to the path of the libraries,
and not to the actual filename. on osx i just have "libclntsh.dylib" in
that directory, and on solaris i have a "libclntsh.so" (amongst others).
i'm not sure about the file with "jdbc" in the name.
also, on my bo
Gene - are you wanting all the records of all the tables into one
output, or do you need to keep the results separated by table?
Are your Excel filenames static or changing?
> -Original Message-
> From: Wolf, Gene [mailto:[EMAIL PROTECTED]
> Sent: Thursday, March 25, 2004 1:33 PM
>
On 25 Mar 2004 at 15:57, Wilcox, Jamileh (HSC) wrote:
> John - have you tried changing the Select Type in a Search Action to
> Summary? I think Witango will do this.
Jamileh is right. Change it to "groups of summaries."
1) Drag tblStudents2003_4.studentID to "columns"
2) If a1 has a primar
John - have you tried changing the Select Type in a Search Action to
Summary? I think Witango will do this.
> -Original Message-
> From: John Newsom [mailto:[EMAIL PROTECTED]
> Sent: Thursday, March 25, 2004 3:32 PM
> To: [EMAIL PROTECTED]
> Subject: RE: Witango-Talk: another sql puzzl
On 25 Mar 2004 at 12:48, John Newsom wrote:
> select count(a1.studentid) as numorders, a1.studentid from
> dbo.maydayShirts a1, dbo.tblStudents2003_4 b1 where b1.yog = '2004'
> group by a1.studentid order by numorders desc
John,
You are getting a "product" of the two tables, because you do not
Windows 2003 Web Edition, R:Tango 5.062, Oterro 2.6
I built a cron taf that writes email to the pickup folder of my SMTP server.
I want to slow this process down as it is pegging the Witango server until
it is done. Other connection requests are being refused.
1) Is their a way to pause between e
Duh! Thanks, Alan. Worked like a charm. Now I wonder why I need to
use a direct sql statement. It seems like the search action ought to be
able to produce simple sql like that!
John
-Original Message-
From: Alan Wolfe [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 25, 2004 1:32 PM
T
Hi John,
In a join like below, you have to have a column that links the 2 tables
together, or else it will select all data from t shirts for every student or
something silly like that and thats why your getting such huge counts.
if tblStudents2003 has a studentid you would do it like this:
selec
I have two tables, one with tshirt orders, one with students, including
year of graduation (yog). I'm trying to get a count of the number of
shirts ordered by each student, selecting only the current seniors.
This statement, which joins the two tables,
select count(a1.studentid) as numorders,
Hi Gene,
Could you build an array with the table names and then loop through the
array doing the work for each table (using the variable in place of where
you would normaly have your constant table name in the DBMS)?
- Original Message -
From: "Wolf, Gene" <[EMAIL PROTECTED]>
To: <[EMAIL
Scott, no, I could do that and that may be a solution. What I have, in essence, is
a single ODBC with what amounts to multiple tables within the "database". All of the
"tables" have the exact same structure so I want to loop through all of the records of
one table, list them, then read all of
Hi Gene,
Not that I understand 100% of what you're doing, but I think you're saying
each Excel file has a different ODBC connection, right?
If you have an array that describes all your Excel file connections, then
you can do a Loop on that and use Variables for your datasource connections
- then
Title: Something completely different
OK, this may be way off the wall but I figured one of you folks would have tried this, or know it can't be done. I have a number of excel spreadsheets that I will be reading data from using Witango. There are about 14 of these sheets and I have working
Someone on the list posted that they had used FileMaker to build a POS
system. I have someone who is a FileMaker developer who would like to talk
with them. Could they please contact me off line and I'll put you two
together.
Dan
--
Dan Stein
Digital Software Solutions
799 Evergreen Circle
Telfo
19 matches
Mail list logo
