Please support our MS SQL advertiser: Programming Forums
Views: 8523 | Replies: 10 | Solved
 |
•
•
Join Date: Jun 2005
Posts: 1
Reputation: 
Rep Power: 0
Solved Threads: 0
Newbie Poster
Hi All,
When I run the query:
select (100/50)
It give me "2"... good.
But when I run the query:
select (50/100)
I was expected it will give me 0.5... but it gives me 0 instead? Why? and How can I get the "0.5"?
When I run the query:
select (100/50)
It give me "2"... good.
But when I run the query:
select (50/100)
I was expected it will give me 0.5... but it gives me 0 instead? Why? and How can I get the "0.5"?
•
•
Join Date: Jun 2005
Location: Texas
Posts: 120
Reputation:
Rep Power: 4
Solved Threads: 5
Junior Poster
change the resulting variable to type double
•
•
Join Date: Aug 2005
Location: Seaham, UK
Posts: 188
Reputation:
Rep Power: 4
Solved Threads: 3
Junior Poster
im not too familiar with sql but i would assume it has something to do with data types maybe? for example if it was integer it would only return a whole number such as 2 or 0 in your case, im not too sure about this in sql as i dont do it but generally that could be the problem
•
•
Join Date: Jun 2005
Location: Texas
Posts: 120
Reputation:
Rep Power: 4
Solved Threads: 5
Junior Poster
try doing your calculations before your sql statment
Dim i As Double Dim MySql as string i = 50 / 100 Mysql="Select " & i & " FROM table;" rs.open MySQl,conn,3,3,1
.: We may acquire liberty, but it is never recovered if it is lost :.
irc://irc.rizon.net/#itf
irc://irc.rizon.net/#itf
•
•
Join Date: Jul 2005
Location: Dallas, TX
Posts: 482
Reputation:
Rep Power: 4
Solved Threads: 19
Posting Pro in Training
or simply "select 50. / 100"
•
•
Join Date: Mar 2007
Posts: 18
Reputation:
Rep Power: 2
Solved Threads: 7
Newbie Poster
It will work fine as long as one of the numbers in division is a float or similar.
Try
This will work with any numeric data.
Try
SQL Syntax (Toggle Plain Text)
•
•
Join Date: Apr 2008
Posts: 295
Reputation:
Rep Power: 1
Solved Threads: 41
Posting Whiz in Training
oops wujtehacjusz, you may have a look at issue date
•
•
Join Date: Mar 2007
Posts: 18
Reputation:
Rep Power: 2
Solved Threads: 7
Newbie Poster
•
•
•
•
Originally Posted by tesuji 
oops wujtehacjusz, you may have a look at issue date
Damn you are right...
|
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Linear Mode
