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
