Forum Home
Press F1
Thread ID: 39741	2003-11-15 22:08:00	Which Server Operating System Setup?	Erin Salmon (626)	Press F1

Post ID	Timestamp	Content	User
192311	2003-11-17 01:16:00	Hi, If I print ( response.write ) the numbers being multiplied, they all have a numerical value. None of the variables are empty, if that's what you mean. Is this what you mean? Cheers, Erin	Erin Salmon (626)
192312	2003-11-17 03:37:00	Microsoft... ****************** Erin - can't comment on suitability for your app, but suspect Server hardware AND SBS "Premium" together should be available for well under NZ$5K. SBS Premium has SQL 2000 and ISA 2000. Licensing is not always straightforward - this may help. CALs are per-device (also a per-user option) for client connection direct to a server app - not relevant to your situation. Another option is an "External Connector Licence" for the server. This might be required if the server authenticates users who access SQL based data. Bit of a grey area - to be certain, suggest asking MS directly. Finally, you may not need a licence for users to access the server. See text (and link to MS) below. www.microsoft.com Q. Why do I need an External Connector license? A. An External Connector (EC) license is not mandatory. It is a licensing option available to address a specific customer scenario. When you need to allow your business partners or customers to access your network, you have two choices: 1/ You can purchase Windows CALs for each one of your external users; or, 2/ You can purchase External Connector licenses for each copy of the Windows Server 2003 software that those external users will access. Note: An example of an external user is a person who is not an employee, or similar personnel of the company or its affiliates. Access via the Internet, in an unauthenticated fashion, does not require a Windows CAL or an EC license-(for example, browsing a public Web site). Regards, Martnz	martnz (271)
192313	2003-11-17 03:44:00	I'm killing myself for even suggesting this, but are you multiplying using the asterisk (*)?	agent (30)
192314	2003-11-17 04:10:00	I didn't know there was anything else you could multiply with...	Erin Salmon (626)
192315	2003-11-17 04:13:00	Hi, Another thing. I can't multiply one of these values by an ordinary number either, such as: ProductPrice = tbProducts("Price") * 1.5 Same error. Are you kidding about the *, or is there something else you can multiply with? Cheers, Erin	Erin Salmon (626)
192316	2003-11-17 04:25:00	I was being a little stupid... in case you absent mindedly tried multiplying with an "x" (fat chance). It might help to specify the database content as numbers (like how you can do that in Access), unless it already is (probably), because I'd think it would have trouble multiplying what it thinks to be text (only containing numbers) by numbers or more text.	agent (30)
192317	2003-11-17 04:43:00	I thought that too ... a database item which can be printed and appears as a number might not be "multipliable". A text string containing a number is not the same as an numeric value. There will, of course, be functions to convert strings to numbers and numbers to strings. :D	Graham L (2)
192318	2003-11-17 04:52:00	Hi, All the database fields in question are numeric - there are two which are decimal(6,3), and one which is decimal(6,2). The fields are numeric, the contents are numeric, and response.write returns numeric values for each one. Works fine for EXACTLY the same database with Access... Is mySQL perhaps pulling something nasty with Binary or Hexadecimal values here? Any other ideas? Cheers, Erin	Erin Salmon (626)
192319	2003-11-17 05:04:00	Looking back ... VBScript says it's "type mismatch". I would believe that ;-). I don't think mySQL is "pulling something with binary or hexadecimal" ... all DBs (and programming languages have various formats for data storage. "Binary" formats of storage are more compact than textual fomats for numbers. I wonder whether the (6,2) ,etc, format might be a text type --- say "123456.12" (where the ".12" is the fractional part, which would be stored without the '.', like "12345612" for space saving. If so, it would need a type conversion function used before it got sent to the arithmetic.	Graham L (2)
192320	2003-11-17 05:37:00	Hi, There are two very good reasons why I think (6,2) is not a text format. 1.) A field of this type in mySQL does not allow you to type text into it; only numbers. 2.) The full name of (6,2) is Decimal(6,2). According to the manual, (6,2) means 6 digits, followed by 2 decimal places. Erin	Erin Salmon (626)
1 2 3 4