Bugs item #1232705, was opened at 2005-07-05 08:02 Message generated for change (Comment added) made by warp9pnt9 You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=105757&aid=1232705&group_id=5757
Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: DynAPI 3 API Group: None Status: Open Resolution: None Priority: 5 Submitted By: conanDrum (conandrum) Assigned to: L W (warp9pnt9) Summary: SQL bigint values lost in SODA object transit Initial Comment: I believe the title says it all. When you access an SQL database and retrieve a bigint value, then stick this into a dictionary object (VB ASP) and return the object to the client (JS HTML), the value on the client is recognised as [NULL]. If you return the value in a string all is well. In General the behaviour is as follows: Return value as: Results in: integer Overflow Error array [NULL] value object [NULL] value string OK ---------------------------------------------------------------------- >Comment By: L W (warp9pnt9) Date: 2005-07-07 22:15 Message: Logged In: YES user_id=706287 I've sent an email to the submitter's users.sourceforge.net address and CCed to DynAPI-Dev mailing list. No response from the submitter. Pasting the message here. Subsequent followup afterwards. ---- BEGIN COPY ---- Hi. I'll try to help you with this so we can both better understand what's going on. Please be patient with me. It's been a while since I touched ASP, and currently do not have a test platform. At present I am only aware of http://domaindlx.com/ with their free ASP hosting with Microsoft Access via connectionless DN with ADODB. If you provide a specific example of what you are trying to do, what you are expecting, and what you are observing, then I will be much closer to understanding the situation. Please do the following to help me: 1) Isolate the specific example of the code that causes the problem. 2) Duplicate the error at DomainDLX. 3) Zip up the files and send to me with your commentary. This will greatly help speed up the process. Wether it's a bug in the code, or in the documentation, or something else, I am not sure so I can't rule anything out at this point. ---- END COPY ---- Upon some inspection of the relevant bits of code, it seems perfectly normal that the data is sent back and forth as text strings. It was designed to do this. So I have to wonder about what is meant by "bigint". Can you further describe the "bigint" you refer to? Number of bits (or min/max), signed or unsigned, and so on. Take such a number in plain JavaScript on your client. Write it as a string, and then pass that string to JavaScript's "parseInt". I think it may be a limitation of the browser's parseInt, or perhaps the client browser's architechture doesn't support a "bigint", or the client program wasn't compiled with support for "bigints". I don't think it has anything to do with SODA. It's just in the middle passing strings. It relies on "parseInt", which relies on the browser, which relies on the math library, which may rely on the OS and CPU. But to be completely sure, please test and report the results. I expect you'll confirm my guess. Otherwise I'll just close this and file it as "not a bug". But if people are going to be using this for bigints, I'll have to update the documentation with this particular "gotcha". Try to test the attached HTML + JavaScript file and use trial and error to find the biggest number that you enter (as a string), and can parse (as an int) and display (as a string again), without losing digits. The biggest/smallest I can get is +/- hex 20 0000 0000 0000 or dec 9007199254740992. Bottom line: you can only use ints that your client's parseInt supports. If you're not doing arithmetic operations on the bigint, then just use it as a string. If you've got to do arithmetic operations, you've got to test your browser capabilities and use only int sizes that are supported. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=105757&aid=1232705&group_id=5757 ------------------------------------------------------- This SF.Net email is sponsored by the 'Do More With Dual!' webinar happening July 14 at 8am PDT/11am EDT. We invite you to explore the latest in dual core and dual graphics technology at this free one hour event hosted by HP, AMD, and NVIDIA. To register visit http://www.hp.com/go/dualwebinar _______________________________________________ Dynapi-Dev mailing list Dynapi-Dev@lists.sourceforge.net http://www.mail-archive.com/dynapi-dev@lists.sourceforge.net/
