In the interest of keeping list messages to a minimum... here's a message to
all with my response to Scott's most recent suggestion first ...
As Scott already knows... his suggested code didn't work:
> <A HREF="<@CGI><@APPFILE>?_function=detail&sysInfo_uid1=<@COLUMN
> "sysInfo.newid" ENCODING=NONE>&<@UserReferenceArgument>"><@COLUMN
> "sysInfo.newid" ENCODING=NONE></A>
>
BUT, when I extrapolated that suggestion along with his earlier suggestion
to try substituting <@CALC EXPR='<@COLUMN "sysInfo.newid"> * 1'> in the
place of <@COLUMN "sysInfo.newid" FORMAT="num:simple-integer"> into my code
and followed the same syntax as he suggested above... the resultant code:
<A HREF="<@CGI><@APPFILE>?_function=detail&sysInfo_uid1=<@CALC
EXPR='<@COLUMN "sysInfo.newid"> * 1'>&<@UserReferenceArgument>"><@CALC
EXPR='<@COLUMN "sysInfo.newid"> * 1'></A>
works to display all my integer 'UIDs' correctly.
Furthermore, if I search out all instances of my previous syntax (used in
Tango 3.52) for either updating or displaying ANY integer values and replace
them with the <@CALC EXPR='<@COLUMN "sysInfo.newid"> * 1'> style code, I'm
now able to both display and update all my data.
So... I'm cranking along updating all my apps... and will be eternally
grateful to Scott for setting me on the right path (and plan to take some
training next month to brush up my very rusty skill set).
Now to reply to the other folks...
1) John McGowan (baffled by this thread)... me too... it used to work with
no effort whatsover but doesn't work now. Furthermore... am not sure why
Scott's suggestions and my interpretation of same works. BUT... my first
rule of computing is that I don't have to understand why it works as long as
I can make it work. To answer your question (what DB am I using)...
* Initial development was done in Tango 3.52 with MS SQL 6.5
and whatever version of MS ODBC that was available then.
* Current environment is SQL 2000, Witango 5.0.1.037 Devel
Studio on win2k and 5.0.1.57 server on win2k and MS ODBC 3.520.90...
2) Bill Conlon... see above to Scott (and yes... my syntax was CLEARLY
outputting the '.')
3) To JJ Smith... our win2k server is logged in as local admin and running
as described above in my reply to John (we have a HUGE AD here and cannot
login our servers onto the network as ourselves because we don't rate high
enough to be admins for entire AD at our site)... I appreciate your
reporting your observations of a couple years back because I was truly
mystified.
Again, thanks to all who replied and I'm going to try to keep my web app hat
on long enough to finish this project up in short order and look forward to
more training at the end of June. My biggest problem is that I wear too many
hats here and don't get to spend huge blocks of time on my tango/witango
apps. It's been OVER TWO YEARS since I've done anything except bare minimum
maintenance of existing simple apps.
E. Victoria Porter, Ph.D.
Scientific Systems Core Facility, DIR, NIDCR
301-496-1622 / Building 49 - Room 1W17
http://wwwdir.nidcr.nih.gov/dirweb/cores/sscf/victoria.asp
> ----------
> From: Scott Cadillac
> Reply To: [EMAIL PROTECTED]
> Sent: Monday, May 17, 2004 6:11 PM
> To: [EMAIL PROTECTED]
> Subject: RE: Witango-Talk: mind numbing (and LONG TERM) problem with
> integer number format
>
> Hi Victoria,
>
> Can you show us exactly (view-source, copy-and-paste) what you get if you
> just do the following in your code?
>
> <A HREF="<@CGI><@APPFILE>?_function=detail&sysInfo_uid1=<@COLUMN
> "sysInfo.newid" ENCODING=NONE>&<@UserReferenceArgument>"><@COLUMN
> "sysInfo.newid" ENCODING=NONE></A>
>
> Let us know, when you have a moment. Cheers....
>
> Scott Cadillac,
> 403-254-5002 ~ [EMAIL PROTECTED]
> ------------
> XML-Extranet ~ http://xmlx.ca ~ http://forums.xmlx.ca
> Well-formed Programming in C# .NET, Witango, MSIE and XML
> ------------
> IExtranet ~ http://iextranet.ca
> Witango ~ http://witango.org
> EasyXSLT ~ http://easyxslt.ca
> IIS Watcher ~ http://iiswatcher.ca
> ------------
> P.O. Box 69006
> RPO Bridlewood SW
> Calgary, Alberta
> Canada T2Y 4T9
>
>
> > -----Original Message-----
> > From: Porter, Victoria (NIH/NIDCR) [mailto:[EMAIL PROTECTED]
> > Sent: Monday, May 17, 2004 2:38 PM
> > To: '[EMAIL PROTECTED]'
> > Subject: RE: Witango-Talk: mind numbing (and LONG TERM)
> > problem with integer number format
> >
> > Thanks for your quick response Scott. I worked my way down
> > your list of
> > suggestions and herewith report the result of trying each one
> > (and have
> > responded to your question as well as added some additional
> > comments and
> > another question (or two) for you as well as a question for
> > the developers).
> >
> > > ----------
> > > From: Scott Cadillac
> > > Reply To: [EMAIL PROTECTED]
> > > Sent: Monday, May 17, 2004 2:28 PM
> > > To: [EMAIL PROTECTED]
> > > Subject: RE: Witango-Talk: mind numbing (and LONG TERM)
> > problem with
> > > integer number format
> > >
> > > Hi Victoria,
> > >
> > > What is returned if you just do <@COLUMN "sysInfo.newid"
> > ENCODING=NONE>?
> > result: same thing (incorrect format)... only numbers
> > aren't links
> > any more
> >
> > > Are you storing your "integer" value in your database with
> > a datatype
> > > other
> > > than "int" (such as a text field)?
> > response: integer values (newid) are stored as int in
> > database (MS
> > SQL)
> >
> > > Have you also tried the supplied format example in the
> > documentation, for
> > > simple-integer?
> > >
> > > <@COLUMN "sysInfo.newid" FORMAT="num:,,0,,,,-,">
> > result: this doesn't work (this is ONE of the reasons why I'm so
> > frustrated... believed this would work and it doesn't so guess we are
> > talking BUG now)
> >
> > > If that doesn't work (bug?), you can always do:
> > >
> > > <@CALC EXPR='<@COLUMN "sysInfo.newid"> * 1'>
> > result: THIS WORKS... but now I have to figure out the
> > equivalent
> > calculation to do when I do the selections ... the updates ... and
> > everywhere else I'm trying to use integer numbers... and I'm
> > just not sure I
> > have the time or energy to devote to this vs devoting time in
> > moving my apps
> > into something else that is more universally used
> >
> > Additional Comments/Questions: Maybe if it's a bug... there's
> > an update that
> > fixes it??? (although I've been seeing this problem since
> > Tango 2000 and
> > heard something once about it being a bug in the ODBC supplied by
> > Microsoft... which also is up to date and I'm still out of
> > luck for things
> > being simple). I had really hoped that when I finally got around to
> > migrating my stuff... this problem would have a ready (and
> > SIMPLE) solution.
> >
> > MAYBE the developers of Witango would like to address why <@COLUMN
> > "sysInfo.newid" FORMAT="num:,,0,,,,-,"> doesn't work to return integer
> > numbers when the number is greater than 3 digits???
> >
> > Anyway, I'm now at the point where I can DISPLAY (in record
> > list) the UID
> > (newid) and other integer values correctly. BUT, when I click
> > the URL (which
> > IS my newid) to bring up the record detail, I get an error
> > for any newid's
> > greater than three digits.
> >
> > A) IF newid is < or = 3 digits... the start of app file (when in
> > debug mode) is as follows when clicking the newid as URL
> > (where the URL =
> > http://genie.nidcr.nih.gov/taf/sscf/admin/searchCPUnew.taf?_fu
> > nction=detail&
> > sysInfo_uid1=191%2E00&_UserReference=907FC0C752D8EEB640A907E9 )
> > START /taf/sscf/admin/searchCPUnew.taf Witango_Server_5
> > _function=detail&sysInfo_uid1=191%2E00&_UserReference=907FC0C7
> > 52D8EEB640A907
> > E9
> >
> > B) IF newid is > 3 digits and I click the newid (URL =
> > http://genie.nidcr.nih.gov/taf/sscf/admin/searchCPUnew.taf?_fu
> > nction=detail&
> > sysInfo_uid1=1%2C495%2E00&_UserReference=907FC0C752D8EEB640A907E9
> > the start of the app file is...
> > > START /taf/sscf/admin/searchCPUnew.taf Witango_Server_5
> > >
> > _function=detail&sysInfo_uid1=1%2C495%2E00&_UserReference=907F
> > C0C752D8EEB6
> > > 40A907E9
> > >
> > So I obviously have more things to figure out with all of
> > this... Tomorrow
> > is another day... have to don my network manager hat and go
> > take care of
> > something else now.
> >
> > > Hope this helps. Cheers...
> > >
> > > Scott Cadillac,
> > > 403-254-5002 ~ [EMAIL PROTECTED]
> > > ------------
> > > XML-Extranet ~ http://xmlx.ca ~ http://forums.xmlx.ca
> > > Well-formed Programming in C# .NET, Witango, MSIE and XML
> > > ------------
> > > IExtranet ~ http://iextranet.ca
> > > Witango ~ http://witango.org
> > > EasyXSLT ~ http://easyxslt.ca
> > > IIS Watcher ~ http://iiswatcher.ca
> > > ------------
> > > P.O. Box 69006
> > > RPO Bridlewood SW
> > > Calgary, Alberta
> > > Canada T2Y 4T9
> > >
> > >
> > > > -----Original Message-----
> > > > From: Porter, Victoria (NIH/NIDCR)
> > [mailto:[EMAIL PROTECTED]
> > > > Sent: Monday, May 17, 2004 11:27 AM
> > > > To: '[EMAIL PROTECTED]'
> > > > Subject: Witango-Talk: mind numbing (and LONG TERM) problem
> > > > with integer number format
> > > >
> > > > This problem has been baffling me for some time (and I've
> > > > avoided solving it
> > > > by sticking with Tango 3.52). However, I'm now almost out of
> > > > time (we must
> > > > kill off our nt4 servers/domain and move ahead into the
> > > > win2k/AD arena) and
> > > > MUST resolve the problem or give up on Tango/Witango as a
> > solution.
> > > >
> > > > <A HREF = "<@CGI><@APPFILE>?_function=detail&sysInfo_uid1=<@COLUMN
> > > > "sysInfo.newid" ENCODING=URL>&<@UserReferenceArgument>"><@COLUMN
> > > > "sysInfo.newid" FORMAT="num:simple-integer"></A>
> > > >
> > > > The above USED to work (tango 3.52) to give integer numbers
> > > > (of the form
> > > > NNNNN) as the result (regardless of whether integer number is
> > > > 2 digit, 3
> > > > digit or 4 digit (or more) number). NOW what happens is that
> > > > numbers LESS
> > > > than three digits are returned as integer numbers (N, NN or
> > > > NNN) whereas
> > > > numbers GREATER than three digits are returned as
> > 1,234.00 formatted
> > > > numbers.
> > > >
> > > > I use "newid" as the selection for records and can not select
> > > > or update with
> > > > what is now being returned as the UID to pull up the
> > > > detail... have even
> > > > resorted to BUILDING the entire query in witango and get
> > to the same
> > > > stumbling block.
> > > >
> > > > I have TRIED several times to figure this out and have failed
> > > > miserably. Am
> > > > using Microsoft ODBC drivers (v3.520.9042.0) on WinXP system
> > > > with Witango
> > > > Studio v 5.0.1.037. Witango server is running on Win2000
> > server and is
> > > > v5.0.1.57.
> > > >
> > > > I have read but cannot comprehend the part of the witango
> > > > Help section on
> > > > formatting numbers. It is beyond me how something that used
> > > > to be so simple
> > > > (num:simple-integer) has become so obscure
> > (num:1,2,3,4,5,6,7,8) with
> > > > explanations that I can't follow to return the numbers the
> > > > way I want them
> > > > returned (as WHOLE UID numbers to use as selection for records).
> > > >
> > > > In addition to my feeling hopelessly stupid, I've managed
> > to stump a
> > > > programmer with YEARS of programming experience who also
> > > > cannot figure out
> > > > the formatting that we need to specify to return INTEGER
> > > > WHOLE NUMBERS with
> > > > no commas and no decimals for our unique ID key on which
> > to select and
> > > > update records
> > > >
> > > > Please note that I'm running out of time to update from v3.52
> > > > to Witango.and
> > > > have observed this phenomenon with ALL my tafs which worked
> > > > beautifully in
> > > > v3.52 of Tango but haven't worked since (either in tango 2000
> > > > as I migrated
> > > > through or in Witango 5).
> > > >
> > > > Humbly begging for a simple/quick fix so I won't have to
> > > > throw away my old
> > > > tango apps in favor of migration to some other product... Victoria
> > > >
> > > > E. Victoria Porter, Ph.D.
> > > > Scientific Systems Core Facility, DIR, NIDCR
> > > > 301-496-1622 / Building 49 - Room 1W17
> > > > http://wwwdir.nidcr.nih.gov/dirweb/cores/sscf/victoria.asp
> > > > ______________________________________________________________
> > > > __________
> > > > TO UNSUBSCRIBE: Go to
> > http://www.witango.com/developer/maillist.taf
> > > >
> > >
> > >
> > >
> > ______________________________________________________________
> > __________
> > > TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
> > >
> > >
> > ______________________________________________________________
> > __________
> > TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
> >
>
>
> ________________________________________________________________________
> TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
>
>
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
