No problem. That looks much better. I still don't understand what the 'group by' is
doing. I'm surprised it lets you group by a column that is not in your select clause,
with no column functions (sum, count, etc).
Its bold to suggests changes to something that works, but, since you are not
thx.
GROUP BY is anachronism (maybe vestigial is better); I forgot to remove
it.
While each tuple (doc_id, kind_id) is unique, I might still need
DISTINCT. As shown, there can be combinations of ORs ANDed together,
which it seems to me would produce some duplicate rows.
If so, then I guess I
Is that anything to do with the vetigial virgin :-)
-Original Message-
From: Bill Conlon [mailto:[EMAIL PROTECTED]
Sent: 16 July 2003 16:45
To: [EMAIL PROTECTED]
Subject: RE: Witango-Talk: OT: SQL help
thx.
GROUP BY is anachronism (maybe vestigial is better); I forgot to remove
it.
I have a table with birthdates and ages. I would like the ages to calculate
automatically so they update when needed.
I guess I could run a cron job and use a taf to update them all.
But SQL 2000 has a place for formula. I just don't understand how to use it.
Dan
--
Dan Stein
Digital Software
Hi there,
Why do you want to store age? Would it be feasible to calculate age each time you want
to use it? SQL Server has all the necessaries for writing expressions in your select
clause and your criteria.
Regards Simon.
-Original Message-
From: Dan Stein [mailto:[EMAIL PROTECTED]
My bad. I had this on a to do list but I don't need it because in fact I am
not storing the age I am calculating it when I need it.
Dan
on 7/16/03 13:24, Simon Boddy at [EMAIL PROTECTED] wrote:
Hi there,
Why do you want to store age? Would it be feasible to calculate age each time
you
Hello all,
I upgraded to the latest app server released a few days back. (061)
At some point I turned debugging on, as I often do. I'm not sure, I may
have turned it on right away, or not, and it may have been on right away
too, I don't recall.
Thing is, I can't turn it off. I turn it on
Did you restart the server after you turned it off?
on 7/16/03 14:50, Andrew at [EMAIL PROTECTED] wrote:
Hello all,
I upgraded to the latest app server released a few days back. (061)
At some point I turned debugging on, as I often do. I'm not sure, I may
have turned it on right
Title: Message
Hi,
I am trying to do an
update on a column called url in a table. Each row in the column
urlis different and has data thatlooks like
this:
http://website/results2.asp?u=244R=onh=usernameo=password1
I would like to do
an update that will only change "password1" to
look at the ENCODING attribute.
Hi,
I am trying to do an update on a column called url in a table. Each row in
the column url is different and has data that looks like this:
http://website/results2.asp?u=244
http://website/results2.asp?u=244R=onh=usernameo=password1
R=onh=usernameo=password1
Dan,
Thanks for the suggestion.. unfortunately I have. I've restarted the app
server, the webserver, the client (browser) and the entire machine.. with
debugmode set to forceoff
Thanks anyway.
Cheers.
- Andrew
At 11:59 AM 7/16/2003, Dan Stein wrote:
Did you restart the server after you
What is 'url'?
@REPLACE STR=url FINDSTR=@VAR vopassword> REPLACESTR=@VAR vnpassword>>
According to the above, the string is a constant 'url'. This should work (check encoding though):
@assign local$url http://website/results2.asp?u=244R=onh=usernameo=password1>
@REPLACE STR=@@local$url
Hi,
I'm trying to send a file with the email action as an attachment through
tango,
and the file is attached but the recipient gets it with a .dat extension ???
what am i missing here???
thanx in advance...
TO
Title: Message
url is
the name of the column I am trying to update, shouldI put @column
name='url' instead?
The
only thing constant in the columns' rows that I am trying to update is "R=onh=usernameo=password1" and everything else before that
can be different. The number of records needed
Title: Message
The reason it works in rbase is due to the
fact that you are within rbase when you run the update.
When you run an update action, witango is
not aware of the values in the current column unless you query them in a search
action prior to the update.
Ben Johansen -
What was the extension of the attachment?
Usually the .dat extension means the email client did not have the
capability to decode the attachment based on it's mime type.
Ben Johansen - http://www.pcforge.com
Authorized Witango Reseller http://www.pcforge.com/WitangoGoodies.htm
Authorized MDaemon
You should know that T2K has a bug in the mail action where
it truncates attachments. It wasn't fixed until Witango 5.
Stefan
At 03:47 PM 7/16/2003 -0500, you wrote:
Hi,
I'm trying to send a file with the email action as an attachment through
tango,
and the file is attached but the recipient
Is there an ODBC on OSX doctor in the house? I'm still swinging at this
one.
On Saturday, July 12, 2003, at 11:13 AM, Roland Dumas wrote:
On laptop, I have a system dsn that points to server and database. it
works. I can built tafs.
On server, I have a system dsn with same attributes, except
Are you doing this directly in the update action? If you are, you must first extract the value of the column url, assign it to a variable, then do your replace function.
Robert.
On Wednesday, July 16, 2003, at 12:54 PM, Ted Wolfley wrote:
url is the name of the column I am trying to update,
you probably need url encoding,
MetaHTML has to do with replacing carriage returns with HTML br tags
url is the name of the column I am trying to update, should I put @column
name='url' instead?
The only thing constant in the columns' rows that I am trying to update is
on the server, does your odbc.ini include port=3306? and database='name
of database'
Is there an ODBC on OSX doctor in the house? I'm still swinging at this
one.
On Saturday, July 12, 2003, at 11:13 AM, Roland Dumas wrote:
On laptop, I have a system dsn that points to server and database. it
Hello List,
When users log in we put some information in the
database about them, including the first 5 digits of the user reference number
so we can match it up in the log with user reference numbers
easier.
We had a user log in on 6/30 with first 5 user ref
digits of 5353C, then they
Hello everyone,
I posted this but it didnt apear so im reposting,
sorry if it shows up twice!
When users log in we put some information in the
database about them, including the first 5 digits of the user reference number
so we can match it up in the log with user reference numbers
Userreference is assigned server side.
I dont know what all goes into
creating it, but I know time is a factor, and it is possible that the first few
chars are base on Hour and Min. and it possible to have that time combo come up
as a start to the userref multiple times during the day.
Is there some way to implement spell checking for a field in a form. Using
windows platform.
--
Dan Stein
Digital Software Solutions
799 Evergreen Circle
Telford PA 18969
Land: 215-799-0192
Mobile: 610-256-2843
Fax 413-410-9682
FMP, WiTango, EDI,SQL 2000
[EMAIL PROTECTED]
www.dss-db.com
Hi,
Ihave a problem (some time) when I
call a External Action like this
16/07/200302:57:0962.10.68.7[EMAIL PROTECTED]18722614
[Error] Can not generate a temporary file
name for the "c:\COMFerra\TraCalc.exe" program specified in the external action
Form this point. all the external call
Hmm, so i guess maybe some parts are more likely to
be unique than other parts.
Thanks for the info Ben...
oh wait, do you know if theres a way in witango to
convert from hex to decimal and back? I only wanted to store the first 5
digits to save on space but storing it as a number instead
Only with a java app as far as I know, or an active x control.
Robert.
On Wednesday, July 16, 2003, at 01:50 PM, Dan Stein wrote:
Is there some way to implement spell checking for a field in a form.
Using
windows platform.
--
Dan Stein
Digital Software Solutions
799 Evergreen Circle
I know nothing about your platform, but are you closing the temporary
files when you finish the External Action.
Most OS's I know of limit the number of files that can be simultaneously
open. Maybe you're hitting the limit.
Hi,
I have a problem (some time) when I call a External Action like
Oh,ithink i found it Ben.
looking in the help for @calc it looks like
you just use the num() function and 0x before the number to convert it to
decimal.
Pretty simple...thanks for the help (:
- Original Message -
From:
Ben Johansen
To: [EMAIL PROTECTED]
Sent:
thanks for the help (:
You
welcome, I think ;-)
Well,
in looking at some collections of USERREF I guess it could be HEX I find no
letter over F
This
blew me away because this drops the number of permutations possible
from base 36 (alphanumeric) to base 16
(hex).
but I
guess it will be
yeah looks like hex to me too
::shrug::
ive never seen anyone use all the letters but that
would be pretty cool (:
- Original Message -
From:
Ben Johansen
To: [EMAIL PROTECTED]
Sent: Wednesday, July 16, 2003 8:15
PM
Subject: RE: Witango-Talk: User
Reference
I believe the user reference is a one way md5 hash, based on the ip address of the user, and I think the time, and maybe something else. It is a hexidecimal string.
Robert.
On Wednesday, July 16, 2003, at 06:34 PM, Ben Johansen wrote:
I dont think the userref is stored as hex Number, but of of
Robert, Atrix,
The USR is a md5 hash, yes if you
are using a single server, it is the users IP and a timestamp, however hashes
are longer than the 24 chars that you see, 48 I think, in any case, Witango cuts
off the end, so it is possible that two USRs created
within a short time of
34 matches
Mail list logo
