In order to get the username from IIS, you need to change the
authentication from the windows type to 'basic' (I think that is the
terminology). Once that is done those using IE will not be
automatically logged in from their Windows credentials, and those not
using IE will be able to use your
Hi,
I am using a DBMS action to retrieve rows from a Rbase database. In the SQL
select code, I am using the IN syntax to retrieve each row's key field that
matches the list of key fields retrieved from another table. It works with
5 key fields in the list and I am wondering if there is a limit
Ted,
There is not a performance hit, unless you don't have an index on the
column that generates the list. Your best bet, since you are using a direct
DBMS action, is a sub-query:
SELECT a, bunch, of, columnnames
FROM maintable
WHERE columnvalue IN (SELECT othertablecolumn FROM
we at one point used alot of this:
SELECT a, bunch, of, columnnames
FROM maintable
WHERE columnvalue IN (@ARRAY request$valuelist APREFIX=''
ASUFFIX='' CPREFIX='' CSUFFIX='' RPREFIX='' RSUFFIX=','0)
but then as our clients collected more data we found out (atleast for R:Base
not sure
Thanks,
I just tested the subquery format and got the same results so I will go with
that since I do not know how large the list will become.
Just a side note, I did not use the 0 with my array variable and I still
retrieved all the data. Is this a glitch or just safe coding?
-Original
On Mon, 8 Sep 2003 15:26:31 -0400, Ted Wolfley wrote:
Just a side note, I did not use the 0 with my array variable and I still
retrieved all the data. Is this a glitch or just safe coding?
Ted,
It may have been a recent clever enhancement to Oterro to let us get away
with that. I know when I
I need to produce valid XHTML 1.0 Transitional -- meaning I need my HTML
tags to close.
How do I get the app server to insert br / instead of br?
Bill Conlon
To the Point
345 California Avenue Suite 2
Palo Alto, CA 94306
office: 650.327.2175
fax:650.329.8335
mobile: 650.906.9929
e-mail:
Ok, Just clarifying here.
I am not using a USER variable in the code I am calling the Search ARG and
replacing the value the Witango placed in the cookie. You could start your
SSL pages with a generic page that doesn't require user variables then have
them click to continue. This would create the
Great prizes
notwithstanding, we have not had very many entries in our Witango Component
Contest. Amazing, because there are a lot of people buying the software
I'm thinking that most of you are too busy to participate in a
contest just now.
Given the response
rate, we're going to