Prev: ASP Content Display (aspx expert)
Next: IIS7 ASP Response object incompatible with MSXML transformNodeToObject
From: zz12 on 29 Jul 2008 05:45 Wow, very interesting information and am grateful for you all for your helpful replies. Sorry if I've sparked some debate with my less than expertise level but I'm sure everyone just meant well even if their forms of communications/perspectives slightly differ and had good intentions in helping me out. Thanks guys totally appreciate your speedy and informative replies :-) "Old Pedant" <OldPedant(a)discussions.microsoft.com> wrote in message news:60A08911-341E-461A-8293-D3D2BCD45FCF(a)microsoft.com... > Incidentally... > > If you are curious what the difference between char10Field and > varchar10Field is, aside from the ADO type number, just change the line > <TD><%=val%></TD> > to > <TD><%=Replace(val," ","^")%></TD> > > If you do that, you'll see that none of the value displays change *EXCEPT* > for the char10Field, and its value is then displayed as > abc^^^^^^^ > > In other words, the char(10) field is space filled to the full size of the > field, just as you woud expect!! > > >
From: Bob Barrows [MVP] on 29 Jul 2008 06:47 Old Pedant wrote: > "Bob Barrows [MVP]" wrote: > >> Incidentally, I agree with your co-worker's decision to move away >> from Float. > > I have to VERY STRONGLY disagree with this statement! > It was late. I said "decision" when I meant "intention". Of course testing should have been done. -- Microsoft MVP - ASP/ASP.NET Please reply to the newsgroup. This email account is my spam trap so I don't check it very often. If you must reply off-line, then remove the "NO SPAM"
From: Bob Barrows [MVP] on 29 Jul 2008 06:50 Old Pedant wrote: > "zz12" wrote: > >> It looks like a co-worker had changed the data type that it uses on >> our SQL Server from 'float' to 'decimal' > > That's the killer! VBScript can *NOT* handle the DECIMAL data > type!!!! > > It can't do *ANY* arithmetic on DECIMAL values. That is not my experience. I never use float and I never have type mismatches when doing math with the retrieved data. Hmmm ... now that I think about it ... that may be because 1. I tend to do math in my sql statements, returning the results and 2. I'm a stickler for doing explicit conversions, even when there is no apparent need for them I will need to do some testing when I have some time. -- Microsoft MVP - ASP/ASP.NET Please reply to the newsgroup. This email account is my spam trap so I don't check it very often. If you must reply off-line, then remove the "NO SPAM"
From: Old Pedant on 29 Jul 2008 14:57 "Anthony Jones" wrote: > I'm rarely bothered by matters of nettiquete and am often irritated when > someone posts a reply merely to correct some matter of netiquette. However > the use of capitals in the above manner is considered to be shouting and you > seem to have a tendancy to use it. I think your opinion is well made and > there is no need to shout. If you would like to emphasise something use > _this point its emphasised_ or *this is also emphasised*. Well, if you'll just convert all my use of all caps to _stuff_ then that's my intention. But, yes, I'll try to work on that. I want to be able to use bold and italic and coloring, and of course you can't do that in usenet. *sigh* No yelling, intended, honest. Just trying to emphasize some things. Actually, even as I wrote it I was bothered by the fact that I needed to keep DECIMAL in all caps, to make sure it was seen as a language term and not just text. So then my "shouting" was all the more confusing. No guarantees I'll break the habit overnight, but I'll try to watch it. Bill Wilkinson
From: Old Pedant on 29 Jul 2008 15:00 "Bob Barrows [MVP]" wrote: > Old Pedant wrote: > > "Bob Barrows [MVP]" wrote: > > > >> Incidentally, I agree with your co-worker's decision to move away > >> from Float. > > > > I have to VERY STRONGLY disagree with this statement! > > > > It was late. I said "decision" when I meant "intention". > Of course testing should have been done. Yes, no argument at all about that statement. And sorry for the apparent shouting. Believe me, I wouldn't shout at you. (Some people, maybe. But I respect your opinions...even when/if I disagree.)
First
|
Prev
|
Next
|
Last
Pages: 1 2 3 4 Prev: ASP Content Display (aspx expert) Next: IIS7 ASP Response object incompatible with MSXML transformNodeToObject |