I'm sure this is an output encoding issue. %2E is encoding '.' -- the period or decimal point. Perhpas this is coming back as a decimal number, that is then output with ENCODING="url" so the decimal is converted to a safe entity.
>I'm baffled by this thread... I output integers from the DB all the time >without any special formatting. and they output as unformatted integers >(no commas or anything) > >What DB are you using? MSSQL? > >/John > >Porter, Victoria (NIH/NIDCR) wrote: > >>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?_function=detail&; >>sysInfo_uid1=191%2E00&_UserReference=907FC0C752D8EEB640A907E9 ) >> START /taf/sscf/admin/searchCPUnew.taf Witango_Server_5 >>_function=detail&sysInfo_uid1=191%2E00&_UserReference=907FC0C752D8EEB640A907 >>E9 >> >> B) IF newid is > 3 digits and I click the newid (URL = >>http://genie.nidcr.nih.gov/taf/sscf/admin/searchCPUnew.taf?_function=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=907FC0C752D8EEB6 >>>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 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: mailto:[EMAIL PROTECTED] web: http://www.tothept.com ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
