|
Hi,
How can I search for codes represent data type decimal(18,2)?
Have a code_textbox and search_button on a form.
have a query to seach code:
select * from commune_table
where (code=@code)
when I put value such as 2.02 no result yet the record is in the table correctly.
Thanks a lot!
|
|
|
|
|
You need to know that most real numbers (float, double) cannot be represented exactly using binary representations. So what is present in the database might well be 2.0199999976 which may be shown by some software as 2.02 but does not exactly equal 2.02
One way of getting around that problem is by not looking for an exact value, look for a range instead (say anything between 2.019 and 2.021). Another way, which I do not recommend, is by converting to string and chopping/rounding, then comparing.
|
|
|
|
|
Hi,
In the table code column shows values as 2.01,2.02 etc..
but if I pass a query for 2.01, I get no returned value.
again code data type as decimal(18,2)
thanks again..
|
|
|
|
|
and how do you pass your value (2.01 or 2.02) so that it ends up in @code?
is everything on its way a decimal, or are some non-exact floats/singles/doubles/reals used in the process?
|
|
|
|
|
Hi,
from a form in a textbox..you can simply in the value, it gets to table as you enter it
thanks
|
|
|
|
|
that is not answering my question.
without getting detailed answers or seeing all the relevant actual code I can't help you.
I repeat: reals/floats/singles/doubles anywhere in your path will cause inexact values in binary.
|
|
|
|
|
|
You should try reading his answer, before you post a new "hint" with a thankyou and hoping that Luc will post the correct code.
You're welcome
I are Troll 
|
|
|
|
|
Now that you had a day's worth of time, try the statement below;
declare @code float
set @code = 2.435
declare @upperBound float
declare @lowerBound float
set @upperBound = @code + .01
set @lowerBound = @code - .01
select *
from commune_table
where code between @lowerBound and @upperBound
The database doesn't store the number "2.1", it stores a number that matches it very closely. That means that if you want to search for such a value, that you'd have to take a margin in account. No, this is not a simple solution to your problem, as you simply cannot search for a fractional number in the database the way you'd search for a string.
I are Troll
|
|
|
|
|
Hi,
In this case, what can I do?
the code list shows as 2.01,2.02
the end user needs to simply search for code from the list.
How can I achieve that..
Or if code represents as 2.0, 2.1,2.2,...2.10, 2.11, etc..what data type to use and would that aid my situation?
thanks..
|
|
|
|
|
I had about a year to find a way to disable ctrl + alt + del in windows vista & 7 in google, but until now I have not got it. Does anyone here know the code? Any help greatly appreciated. Thank you!
modified on Wednesday, January 5, 2011 6:26 AM
|
|
|
|
|
Are you after stopping people from pressing that combo in your application or to stop the windows combo?
As barmey as a sack of badgers
Dude, if I knew what I was doing in life, I'd be rich, retired, dating a supermodel and laughing at the rest of you from the sidelines.
|
|
|
|
|
|
It's a reserved combination, not meant to be disabled. A standard application cannot intercept the combination out of security-reasons.
I have yet to hear a good reason to disable that particular combination.
I are Troll
|
|
|
|
|
This may be done in windows xp. Is it because in windows xp this combination key just to bring up windows task manager? While on vista & 7 are not. It is for my i-cafe software, so i need to disable CTRL+ALT+DEL.
|
|
|
|
|
Yance Lawang wrote: It is for my i-cafe software, so i need to disable CTRL+ALT+DEL
No, you want to prevent users from getting into your system - the difference being that there might be more ways to accomplish that, even though you have a specific technical solution in mind.
You could disable it with a group-policy. Windows SteadyState might be usable too, but you'd have to verify that with someone who actually used it
I are Troll
|
|
|
|
|
Good answer.
------------------------------------
I will never again mention that I was the poster of the One Millionth Lounge Post, nor that it was complete drivel. Dalek Dave
CCC League Table Link
CCC Link[ ^]
|
|
|
|
|
Thanks
|
|
|
|
|
Of course, every system must have a gap to be penetrated. But is there any way to disable CTRL + ALT + DEL in win 7 like on windows xp? One example of such in Lock Windows Desktop[^]
|
|
|
|
|
You can't find any code because you can't disable Ctrl-Alt-Del at all. This key combination doesn't even make it to the user desktop. It is handled by WinLogon which is responsible for showing the Secure Attention Sequence desktop.
You can disable or restrict everything you can do in that desktop using Group Policy. Doing it from your code is not a good idea, especially if you are not writing your app as a Windows service.
|
|
|
|
|
How about running in XP-mode?
|
|
|
|
|
How about remove the keys from the keyboard?
|
|
|
|
|
That's not gonna help you, I'm bringin' my own USB-keyboard; you prepared to lock down the entire station?
I are Troll 
|
|
|
|
|
You may want to perform some Google searches. Look for Windows in combination with either GINA or kiosk mode.
|
|
|
|
|
Dim objCmd As New ADODB.Command
Dim objparameter As New ADODB.Parameter
Dim objRs As New ADODB.Recordset
Dim con2 As New ADODB.Connection
Dim xmlstr, clisttype, clistremarks, clistfdate, clisttdate, cno, cjudge1, cjudge2, cjudge3, constr As String
xmlstr = "<?xml version=""1.0"" encoding=""iso-8859-1"" ?><causelist><date>"
constr = " Provider=MSDataShape;Persist Security Info=False;Data Source=10.130.8.15;User ID=sa;Password=sa;Initial Catalog=dbname;Data Provider=SQLOLEDB.1"
'chandak
xmlstr = xmlstr + "<causelisttodate>" & clisttdate & "</causelisttodate>"
xmlstr = xmlstr + "<causelistfromdate>" & clistfdate & "</causelistfromdate>"
xmlstr = xmlstr + "<common_remarks>" & clistremarks & "</common_remarks>"
xmlstr = xmlstr + "<end_remarks>" & clistremarks & "</end_remarks>"
xmlstr = xmlstr + "<court>"
xmlstr = xmlstr + "<courtno>" & cno & "</courtno>"
xmlstr = xmlstr + "<courtremarks></courtremarks>"
xmlstr = xmlstr + "<judge1>" & cjudge1 & "</judge1>"
xmlstr = xmlstr + "<judge2></judge2>"
xmlstr = xmlstr + "<judge3></judge3>"
xmlstr = xmlstr + "<judge4></judge4>"
xmlstr = xmlstr + "<judge5></judge5>"
con2.Open constr
objCmd.ActiveConnection = con2
objCmd.CommandType = adCmdStoredProc
objCmd.CommandText = "causelistxml"
objCmd.Parameters.Append objCmd.CreateParameter("date", adVarChar, adParamInput, 10, Text1.Text)
objCmd.Parameters.Append objCmd.CreateParameter("courtno", adVarChar, adParamInput, 10, Text2.Text)
objCmd.Parameters.Append objCmd.CreateParameter("courtno2", adVarChar, adParamInput, 10, Croom)
objCmd.Parameters.Append objCmd.CreateParameter("date2", adVarChar, adParamInput, 10, clistfdate)
objCmd.Parameters.Append objCmd.CreateParameter("alloted", adVarChar, adParamInput, 10, Alloted)
'objRs.Open con, adOpenStatic, adLockReadOnly
Dim pstage As String
Dim ii As Integer
'ii = objRs.RecordCount
pstage = ""
Set objRs = objCmd.Execute
'con.Open constr
'OpenConnection
objRs.Open
'objRs.Open objCmd, adOpenStatic, adLockReadOnly
For ii = 0 To objRs.RecordCount
xmlstr = xmlstr + objRs.Fields("part1") + objRs.Fields("part2")
Next ii
'If Not objRs.EOF Then
'Do While Not (objRs.EOF)
' xmlstr = xmlstr + objRs.Fields(0) + objRs.Fields(1)
' objRs.MoveNext
' Loop
' End If
Set objCmd.ActiveConnection = Nothing
objRs.Close
I used debug when cursor focus on for loop, Its throw a Error :
Run Time Error '3704'
Operation is not allowed when the the object is closed
Help plz.......
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
