Hi,
I have a problem converting text to a double. Why doesn't the code work:
If Not (txtdocbedrag.Text = "") Then
Select Case ddlBedrag.SelectedIndex
Case 0
Case 1
whereSQL += "cast(bedrag as numeric(10,2)) > '" &
Double.Parse(txtdocbedrag.Text) & "' and "
Case 2
whereSQL += "cast(bedrag as numeric(10,2)) >= '" &
Double.Parse(txtdocbedrag.Text) & "' and "
Case 3
whereSQL += "cast(bedrag as numeric(10,2)) < '" &
Double.Parse(txtdocbedrag.Text) & "' and "
Case 4
whereSQL += "cast(bedrag as numeric(10,2)) <= '" &
Double.Parse(txtdocbedrag.Text) & "' and "
Case 5
whereSQL += "cast(bedrag as numeric(10,2)) = '" &
Double.Parse(txtdocbedrag.Text) & "' and "
Case 6
whereSQL += "cast(bedrag as numeric(10,2)) >= '" &
Double.Parse(txtdocbedrag.Text) & "' cast(bedrag as numeric(10,2)) < '" &
Double.Parse(txtBedragTot.Text) & "' and "
End Select
End If
12  3122 
"Frederik Vanderhaeghe" <fr******************@gmail.com> wrote in message
news:%2****************@TK2MSFTNGP02.phx.gbl... Hi,
I have a problem converting text to a double. Why doesn't the code work:
If Not (txtdocbedrag.Text = "") Then
Select Case ddlBedrag.SelectedIndex
Case 0
Case 1
whereSQL += "cast(bedrag as numeric(10,2)) > '" &
Double.Parse(txtdocbedrag.Text) & "' and "
Case 2
whereSQL += "cast(bedrag as numeric(10,2)) >= '" &
Double.Parse(txtdocbedrag.Text) & "' and "
Case 3
whereSQL += "cast(bedrag as numeric(10,2)) < '" &
Double.Parse(txtdocbedrag.Text) & "' and "
Case 4
whereSQL += "cast(bedrag as numeric(10,2)) <= '" &
Double.Parse(txtdocbedrag.Text) & "' and "
Case 5
whereSQL += "cast(bedrag as numeric(10,2)) = '" &
Double.Parse(txtdocbedrag.Text) & "' and "
Case 6
whereSQL += "cast(bedrag as numeric(10,2)) >= '" &
Double.Parse(txtdocbedrag.Text) & "' cast(bedrag as numeric(10,2)) < '" &
Double.Parse(txtBedragTot.Text) & "' and "
End Select
End If
One thing I spotted is the use of single quote punctuation around a numeric
value (the result of Double.Parse(...).
In your SQL query (that is what you're building, correct?), numeric values
should have no punctuation characters surrounding them. String values need
single quotes, as to dates (in SQL Server. Access date punctuation is the
#.).
--
Peter [MVP Visual Developer]
Jack of all trades, master of none.
I dont know but converting a string to a double does work:
Dim st As String = "2.0"
Dim d As Double
d = Double.Parse(st)
"Frederik Vanderhaeghe" <fr******************@gmail.com> wrote in message
news:%2****************@TK2MSFTNGP02.phx.gbl... Hi,
I have a problem converting text to a double. Why doesn't the code work:
If Not (txtdocbedrag.Text = "") Then
Select Case ddlBedrag.SelectedIndex
Case 0
Case 1
whereSQL += "cast(bedrag as numeric(10,2)) > '" &
Double.Parse(txtdocbedrag.Text) & "' and "
Case 2
whereSQL += "cast(bedrag as numeric(10,2)) >= '" &
Double.Parse(txtdocbedrag.Text) & "' and "
Case 3
whereSQL += "cast(bedrag as numeric(10,2)) < '" &
Double.Parse(txtdocbedrag.Text) & "' and "
Case 4
whereSQL += "cast(bedrag as numeric(10,2)) <= '" &
Double.Parse(txtdocbedrag.Text) & "' and "
Case 5
whereSQL += "cast(bedrag as numeric(10,2)) = '" &
Double.Parse(txtdocbedrag.Text) & "' and "
Case 6
whereSQL += "cast(bedrag as numeric(10,2)) >= '" &
Double.Parse(txtdocbedrag.Text) & "' cast(bedrag as numeric(10,2)) < '" &
Double.Parse(txtBedragTot.Text) & "' and "
End Select
End If
but the problem is the "cast(bedrag as numeric(10,2)"
bedrag=databasefield
"Pipo" <Pa****@Mayo.com> wrote in message
news:OR**************@TK2MSFTNGP02.phx.gbl... I dont know but converting a string to a double does work:
Dim st As String = "2.0"
Dim d As Double
d = Double.Parse(st)
"Frederik Vanderhaeghe" <fr******************@gmail.com> wrote in message
news:%2****************@TK2MSFTNGP02.phx.gbl... Hi,
I have a problem converting text to a double. Why doesn't the code work:
If Not (txtdocbedrag.Text = "") Then
Select Case ddlBedrag.SelectedIndex
Case 0
Case 1
whereSQL += "cast(bedrag as numeric(10,2)) > '" &
Double.Parse(txtdocbedrag.Text) & "' and "
Case 2
whereSQL += "cast(bedrag as numeric(10,2)) >= '" &
Double.Parse(txtdocbedrag.Text) & "' and "
Case 3
whereSQL += "cast(bedrag as numeric(10,2)) < '" &
Double.Parse(txtdocbedrag.Text) & "' and "
Case 4
whereSQL += "cast(bedrag as numeric(10,2)) <= '" &
Double.Parse(txtdocbedrag.Text) & "' and "
Case 5
whereSQL += "cast(bedrag as numeric(10,2)) = '" &
Double.Parse(txtdocbedrag.Text) & "' and "
Case 6
whereSQL += "cast(bedrag as numeric(10,2)) >= '" &
Double.Parse(txtdocbedrag.Text) & "' cast(bedrag as numeric(10,2)) < '" &
Double.Parse(txtBedragTot.Text) & "' and "
End Select
End If
Define "doesn't work". Are you getting an error?
And what kind of syntax is "bedrag=databasefield".
apples=oranges
May I suggest you use some sort of meaningful naming convention?
Jeff
"Frederik Vanderhaeghe" <fr******************@gmail.com> wrote in message
news:up**************@TK2MSFTNGP05.phx.gbl... but the problem is the "cast(bedrag as numeric(10,2)"
bedrag=databasefield
"Pipo" <Pa****@Mayo.com> wrote in message
news:OR**************@TK2MSFTNGP02.phx.gbl...I dont know but converting a string to a double does work:
Dim st As String = "2.0"
Dim d As Double
d = Double.Parse(st)
"Frederik Vanderhaeghe" <fr******************@gmail.com> wrote in message
news:%2****************@TK2MSFTNGP02.phx.gbl... Hi,
I have a problem converting text to a double. Why doesn't the code work:
If Not (txtdocbedrag.Text = "") Then
Select Case ddlBedrag.SelectedIndex
Case 0
Case 1
whereSQL += "cast(bedrag as numeric(10,2)) > '" &
Double.Parse(txtdocbedrag.Text) & "' and "
Case 2
whereSQL += "cast(bedrag as numeric(10,2)) >= '" &
Double.Parse(txtdocbedrag.Text) & "' and "
Case 3
whereSQL += "cast(bedrag as numeric(10,2)) < '" &
Double.Parse(txtdocbedrag.Text) & "' and "
Case 4
whereSQL += "cast(bedrag as numeric(10,2)) <= '" &
Double.Parse(txtdocbedrag.Text) & "' and "
Case 5
whereSQL += "cast(bedrag as numeric(10,2)) = '" &
Double.Parse(txtdocbedrag.Text) & "' and "
Case 6
whereSQL += "cast(bedrag as numeric(10,2)) >= '" &
Double.Parse(txtdocbedrag.Text) & "' cast(bedrag as numeric(10,2)) < '"
& Double.Parse(txtBedragTot.Text) & "' and "
End Select
End If
bedrag = databasefield is not a syntax it was just saying that it is a field
from the database, it's not in the code.
The eroor i get is: Error converting data type varchar to numeric
"Jeff Dillon" <je********@hotmail.com> wrote in message
news:%2****************@TK2MSFTNGP02.phx.gbl... Define "doesn't work". Are you getting an error?
And what kind of syntax is "bedrag=databasefield".
apples=oranges
May I suggest you use some sort of meaningful naming convention?
Jeff
"Frederik Vanderhaeghe" <fr******************@gmail.com> wrote in message
news:up**************@TK2MSFTNGP05.phx.gbl... but the problem is the "cast(bedrag as numeric(10,2)"
bedrag=databasefield
"Pipo" <Pa****@Mayo.com> wrote in message
news:OR**************@TK2MSFTNGP02.phx.gbl...I dont know but converting a string to a double does work:
Dim st As String = "2.0"
Dim d As Double
d = Double.Parse(st)
"Frederik Vanderhaeghe" <fr******************@gmail.com> wrote in
message news:%2****************@TK2MSFTNGP02.phx.gbl...
Hi,
I have a problem converting text to a double. Why doesn't the code
work:
If Not (txtdocbedrag.Text = "") Then
Select Case ddlBedrag.SelectedIndex
Case 0
Case 1
whereSQL += "cast(bedrag as numeric(10,2)) > '" &
Double.Parse(txtdocbedrag.Text) & "' and "
Case 2
whereSQL += "cast(bedrag as numeric(10,2)) >= '" &
Double.Parse(txtdocbedrag.Text) & "' and "
Case 3
whereSQL += "cast(bedrag as numeric(10,2)) < '" &
Double.Parse(txtdocbedrag.Text) & "' and "
Case 4
whereSQL += "cast(bedrag as numeric(10,2)) <= '" &
Double.Parse(txtdocbedrag.Text) & "' and "
Case 5
whereSQL += "cast(bedrag as numeric(10,2)) = '" &
Double.Parse(txtdocbedrag.Text) & "' and "
Case 6
whereSQL += "cast(bedrag as numeric(10,2)) >= '" &
Double.Parse(txtdocbedrag.Text) & "' cast(bedrag as numeric(10,2)) < '"
& Double.Parse(txtBedragTot.Text) & "' and "
End Select
End If
What is the value of bedrag then?
Are you trying to convert text to a double?
Double.Parse("SomeText") wont work ofcourse.
"Frederik Vanderhaeghe" <fr******************@gmail.com> wrote in message
news:%2****************@TK2MSFTNGP05.phx.gbl... bedrag = databasefield is not a syntax it was just saying that it is a
field from the database, it's not in the code.
The eroor i get is: Error converting data type varchar to numeric
"Jeff Dillon" <je********@hotmail.com> wrote in message
news:%2****************@TK2MSFTNGP02.phx.gbl... Define "doesn't work". Are you getting an error?
And what kind of syntax is "bedrag=databasefield".
apples=oranges
May I suggest you use some sort of meaningful naming convention?
Jeff
"Frederik Vanderhaeghe" <fr******************@gmail.com> wrote in message
news:up**************@TK2MSFTNGP05.phx.gbl... but the problem is the "cast(bedrag as numeric(10,2)"
bedrag=databasefield
"Pipo" <Pa****@Mayo.com> wrote in message
news:OR**************@TK2MSFTNGP02.phx.gbl...
I dont know but converting a string to a double does work:
Dim st As String = "2.0"
Dim d As Double
d = Double.Parse(st)
"Frederik Vanderhaeghe" <fr******************@gmail.com> wrote in
message news:%2****************@TK2MSFTNGP02.phx.gbl...
> Hi,
>
> I have a problem converting text to a double. Why doesn't the code
> work:
> If Not (txtdocbedrag.Text = "") Then
>
> Select Case ddlBedrag.SelectedIndex
>
> Case 0
>
> Case 1
>
> whereSQL += "cast(bedrag as numeric(10,2)) > '" &
> Double.Parse(txtdocbedrag.Text) & "' and "
>
> Case 2
>
> whereSQL += "cast(bedrag as numeric(10,2)) >= '" &
> Double.Parse(txtdocbedrag.Text) & "' and "
>
> Case 3
>
> whereSQL += "cast(bedrag as numeric(10,2)) < '" &
> Double.Parse(txtdocbedrag.Text) & "' and "
>
> Case 4
>
> whereSQL += "cast(bedrag as numeric(10,2)) <= '" &
> Double.Parse(txtdocbedrag.Text) & "' and "
>
> Case 5
>
> whereSQL += "cast(bedrag as numeric(10,2)) = '" &
> Double.Parse(txtdocbedrag.Text) & "' and "
>
> Case 6
>
> whereSQL += "cast(bedrag as numeric(10,2)) >= '" &
> Double.Parse(txtdocbedrag.Text) & "' cast(bedrag as numeric(10,2)) <
> '" & Double.Parse(txtBedragTot.Text) & "' and "
>
> End Select
>
> End If
>
>
bedrag is varchar in the database. I have to compare the varchar out of the
database with a value in a textbox, so i convert the varchar to double and i
parse the textbox value to double.
"Pipo" <Pa****@Mayo.com> wrote in message
news:eS**************@TK2MSFTNGP05.phx.gbl... What is the value of bedrag then?
Are you trying to convert text to a double?
Double.Parse("SomeText") wont work ofcourse.
"Frederik Vanderhaeghe" <fr******************@gmail.com> wrote in message
news:%2****************@TK2MSFTNGP05.phx.gbl... bedrag = databasefield is not a syntax it was just saying that it is a
field from the database, it's not in the code.
The eroor i get is: Error converting data type varchar to numeric
"Jeff Dillon" <je********@hotmail.com> wrote in message
news:%2****************@TK2MSFTNGP02.phx.gbl... Define "doesn't work". Are you getting an error?
And what kind of syntax is "bedrag=databasefield".
apples=oranges
May I suggest you use some sort of meaningful naming convention?
Jeff
"Frederik Vanderhaeghe" <fr******************@gmail.com> wrote in
message news:up**************@TK2MSFTNGP05.phx.gbl...
but the problem is the "cast(bedrag as numeric(10,2)"
bedrag=databasefield
"Pipo" <Pa****@Mayo.com> wrote in message
news:OR**************@TK2MSFTNGP02.phx.gbl...
>I dont know but converting a string to a double does work:
> Dim st As String = "2.0"
> Dim d As Double
> d = Double.Parse(st)
>
>
> "Frederik Vanderhaeghe" <fr******************@gmail.com> wrote in
> message news:%2****************@TK2MSFTNGP02.phx.gbl...
>> Hi,
>>
>> I have a problem converting text to a double. Why doesn't the code
>> work:
>> If Not (txtdocbedrag.Text = "") Then
>>
>> Select Case ddlBedrag.SelectedIndex
>>
>> Case 0
>>
>> Case 1
>>
>> whereSQL += "cast(bedrag as numeric(10,2)) > '" &
>> Double.Parse(txtdocbedrag.Text) & "' and "
>>
>> Case 2
>>
>> whereSQL += "cast(bedrag as numeric(10,2)) >= '" &
>> Double.Parse(txtdocbedrag.Text) & "' and "
>>
>> Case 3
>>
>> whereSQL += "cast(bedrag as numeric(10,2)) < '" &
>> Double.Parse(txtdocbedrag.Text) & "' and "
>>
>> Case 4
>>
>> whereSQL += "cast(bedrag as numeric(10,2)) <= '" &
>> Double.Parse(txtdocbedrag.Text) & "' and "
>>
>> Case 5
>>
>> whereSQL += "cast(bedrag as numeric(10,2)) = '" &
>> Double.Parse(txtdocbedrag.Text) & "' and "
>>
>> Case 6
>>
>> whereSQL += "cast(bedrag as numeric(10,2)) >= '" &
>> Double.Parse(txtdocbedrag.Text) & "' cast(bedrag as numeric(10,2)) <
>> '" & Double.Parse(txtBedragTot.Text) & "' and "
>>
>> End Select
>>
>> End If
>>
>>
>
>
Post the exact line, and the value of all variables, that is generating the
error. You can use CDbl too
Jeff
"Frederik Vanderhaeghe" <fr******************@gmail.com> wrote in message
news:ub**************@TK2MSFTNGP05.phx.gbl... bedrag is varchar in the database. I have to compare the varchar out of
the database with a value in a textbox, so i convert the varchar to double
and i parse the textbox value to double.
"Pipo" <Pa****@Mayo.com> wrote in message
news:eS**************@TK2MSFTNGP05.phx.gbl... What is the value of bedrag then?
Are you trying to convert text to a double?
Double.Parse("SomeText") wont work ofcourse.
"Frederik Vanderhaeghe" <fr******************@gmail.com> wrote in message
news:%2****************@TK2MSFTNGP05.phx.gbl... bedrag = databasefield is not a syntax it was just saying that it is a
field from the database, it's not in the code.
The eroor i get is: Error converting data type varchar to numeric
"Jeff Dillon" <je********@hotmail.com> wrote in message
news:%2****************@TK2MSFTNGP02.phx.gbl...
Define "doesn't work". Are you getting an error?
And what kind of syntax is "bedrag=databasefield".
apples=oranges
May I suggest you use some sort of meaningful naming convention?
Jeff
"Frederik Vanderhaeghe" <fr******************@gmail.com> wrote in
message news:up**************@TK2MSFTNGP05.phx.gbl...
> but the problem is the "cast(bedrag as numeric(10,2)"
> bedrag=databasefield
> "Pipo" <Pa****@Mayo.com> wrote in message
> news:OR**************@TK2MSFTNGP02.phx.gbl...
>>I dont know but converting a string to a double does work:
>> Dim st As String = "2.0"
>> Dim d As Double
>> d = Double.Parse(st)
>>
>>
>> "Frederik Vanderhaeghe" <fr******************@gmail.com> wrote in
>> message news:%2****************@TK2MSFTNGP02.phx.gbl...
>>> Hi,
>>>
>>> I have a problem converting text to a double. Why doesn't the code
>>> work:
>>> If Not (txtdocbedrag.Text = "") Then
>>>
>>> Select Case ddlBedrag.SelectedIndex
>>>
>>> Case 0
>>>
>>> Case 1
>>>
>>> whereSQL += "cast(bedrag as numeric(10,2)) > '" &
>>> Double.Parse(txtdocbedrag.Text) & "' and "
>>>
>>> Case 2
>>>
>>> whereSQL += "cast(bedrag as numeric(10,2)) >= '" &
>>> Double.Parse(txtdocbedrag.Text) & "' and "
>>>
>>> Case 3
>>>
>>> whereSQL += "cast(bedrag as numeric(10,2)) < '" &
>>> Double.Parse(txtdocbedrag.Text) & "' and "
>>>
>>> Case 4
>>>
>>> whereSQL += "cast(bedrag as numeric(10,2)) <= '" &
>>> Double.Parse(txtdocbedrag.Text) & "' and "
>>>
>>> Case 5
>>>
>>> whereSQL += "cast(bedrag as numeric(10,2)) = '" &
>>> Double.Parse(txtdocbedrag.Text) & "' and "
>>>
>>> Case 6
>>>
>>> whereSQL += "cast(bedrag as numeric(10,2)) >= '" &
>>> Double.Parse(txtdocbedrag.Text) & "' cast(bedrag as numeric(10,2)) <
>>> '" & Double.Parse(txtBedragTot.Text) & "' and "
>>>
>>> End Select
>>>
>>> End If
>>>
>>>
>>
>>
>
>
whereSQL += "cast(bedrag as numeric(10,2)) > '" & Double.Parse(txtdocbedrag.Text) & "' and "
Bedrag = varchar with a
"Jeff Dillon" <je********@hotmail.com> wrote in message
news:OW**************@TK2MSFTNGP03.phx.gbl... Post the exact line, and the value of all variables, that is generating
the error. You can use CDbl too
Jeff
"Frederik Vanderhaeghe" <fr******************@gmail.com> wrote in message
news:ub**************@TK2MSFTNGP05.phx.gbl... bedrag is varchar in the database. I have to compare the varchar out of
the database with a value in a textbox, so i convert the varchar to
double and i parse the textbox value to double.
"Pipo" <Pa****@Mayo.com> wrote in message
news:eS**************@TK2MSFTNGP05.phx.gbl... What is the value of bedrag then?
Are you trying to convert text to a double?
Double.Parse("SomeText") wont work ofcourse.
"Frederik Vanderhaeghe" <fr******************@gmail.com> wrote in
message news:%2****************@TK2MSFTNGP05.phx.gbl...
bedrag = databasefield is not a syntax it was just saying that it is a
field from the database, it's not in the code.
The eroor i get is: Error converting data type varchar to numeric
"Jeff Dillon" <je********@hotmail.com> wrote in message
news:%2****************@TK2MSFTNGP02.phx.gbl...
> Define "doesn't work". Are you getting an error?
>
> And what kind of syntax is "bedrag=databasefield".
>
> apples=oranges
>
> May I suggest you use some sort of meaningful naming convention?
>
> Jeff
>
> "Frederik Vanderhaeghe" <fr******************@gmail.com> wrote in
> message news:up**************@TK2MSFTNGP05.phx.gbl...
>> but the problem is the "cast(bedrag as numeric(10,2)"
>> bedrag=databasefield
>> "Pipo" <Pa****@Mayo.com> wrote in message
>> news:OR**************@TK2MSFTNGP02.phx.gbl...
>>>I dont know but converting a string to a double does work:
>>> Dim st As String = "2.0"
>>> Dim d As Double
>>> d = Double.Parse(st)
>>>
>>>
>>> "Frederik Vanderhaeghe" <fr******************@gmail.com> wrote in
>>> message news:%2****************@TK2MSFTNGP02.phx.gbl...
>>>> Hi,
>>>>
>>>> I have a problem converting text to a double. Why doesn't the code
>>>> work:
>>>> If Not (txtdocbedrag.Text = "") Then
>>>>
>>>> Select Case ddlBedrag.SelectedIndex
>>>>
>>>> Case 0
>>>>
>>>> Case 1
>>>>
>>>> whereSQL += "cast(bedrag as numeric(10,2)) > '" &
>>>> Double.Parse(txtdocbedrag.Text) & "' and "
>>>>
>>>> Case 2
>>>>
>>>> whereSQL += "cast(bedrag as numeric(10,2)) >= '" &
>>>> Double.Parse(txtdocbedrag.Text) & "' and "
>>>>
>>>> Case 3
>>>>
>>>> whereSQL += "cast(bedrag as numeric(10,2)) < '" &
>>>> Double.Parse(txtdocbedrag.Text) & "' and "
>>>>
>>>> Case 4
>>>>
>>>> whereSQL += "cast(bedrag as numeric(10,2)) <= '" &
>>>> Double.Parse(txtdocbedrag.Text) & "' and "
>>>>
>>>> Case 5
>>>>
>>>> whereSQL += "cast(bedrag as numeric(10,2)) = '" &
>>>> Double.Parse(txtdocbedrag.Text) & "' and "
>>>>
>>>> Case 6
>>>>
>>>> whereSQL += "cast(bedrag as numeric(10,2)) >= '" &
>>>> Double.Parse(txtdocbedrag.Text) & "' cast(bedrag as numeric(10,2))
>>>> < '" & Double.Parse(txtBedragTot.Text) & "' and "
>>>>
>>>> End Select
>>>>
>>>> End If
>>>>
>>>>
>>>
>>>
>>
>>
>
>
then don't do that (?)
Obviously double.parse is failing. Catch the exception, and debug the
results.
Response.write, instead of issuing the sql (duh)
txtdocbedrag.text contains text you don't expect. Find out why
I find it amazing, and almost sad, the programmers these days can't figure
out reproducible problems.
I'm 50. I had issues like this 25 years ago, but before newgroups, granted.
Just my opinion
"Frederik Vanderhaeghe" <fr******************@gmail.com> wrote in message
news:%2****************@TK2MSFTNGP05.phx.gbl... whereSQL += "cast(bedrag as numeric(10,2)) > '" & Double.Parse(txtdocbedrag.Text) & "' and "
Bedrag = varchar with a
"Jeff Dillon" <je********@hotmail.com> wrote in message
news:OW**************@TK2MSFTNGP03.phx.gbl... Post the exact line, and the value of all variables, that is generating
the error. You can use CDbl too
It's not the double.parse that is failing, its the convert in sql!
"Jeff Dillon" <je********@hotmail.com> wrote in message
news:uq**************@TK2MSFTNGP03.phx.gbl... then don't do that (?)
Obviously double.parse is failing. Catch the exception, and debug the
results.
Response.write, instead of issuing the sql (duh)
txtdocbedrag.text contains text you don't expect. Find out why
I find it amazing, and almost sad, the programmers these days can't figure
out reproducible problems.
I'm 50. I had issues like this 25 years ago, but before newgroups,
granted.
Just my opinion
"Frederik Vanderhaeghe" <fr******************@gmail.com> wrote in message
news:%2****************@TK2MSFTNGP05.phx.gbl... whereSQL += "cast(bedrag as numeric(10,2)) > '" & Double.Parse(txtdocbedrag.Text) & "' and "
Bedrag = varchar with a
"Jeff Dillon" <je********@hotmail.com> wrote in message
news:OW**************@TK2MSFTNGP03.phx.gbl... Post the exact line, and the value of all variables, that is generating
the error. You can use CDbl too
Please show the resultant SQL
response.write strSQL
but don't actually execute it.
Jeff
"Frederik Vanderhaeghe" <fr******************@gmail.com> wrote in message
news:Of**************@TK2MSFTNGP02.phx.gbl... It's not the double.parse that is failing, its the convert in sql!
"Jeff Dillon" <je********@hotmail.com> wrote in message
news:uq**************@TK2MSFTNGP03.phx.gbl... then don't do that (?)
Obviously double.parse is failing. Catch the exception, and debug the
results.
Response.write, instead of issuing the sql (duh)
txtdocbedrag.text contains text you don't expect. Find out why
I find it amazing, and almost sad, the programmers these days can't
figure out reproducible problems.
I'm 50. I had issues like this 25 years ago, but before newgroups,
granted.
Just my opinion
"Frederik Vanderhaeghe" <fr******************@gmail.com> wrote in message
news:%2****************@TK2MSFTNGP05.phx.gbl... whereSQL += "cast(bedrag as numeric(10,2)) > '" &
Double.Parse(txtdocbedrag.Text) & "' and "
Bedrag = varchar with a
"Jeff Dillon" <je********@hotmail.com> wrote in message
news:OW**************@TK2MSFTNGP03.phx.gbl...
Post the exact line, and the value of all variables, that is generating
the error. You can use CDbl too
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: shang |
last post by:
Hi!
I am trying to find a function that converts a string into a double
or a long double number. I found atod() but I don't know which library
I have to include to use it. Could someone help me?
...
|
by: Kent Lewandowski |
last post by:
Hi,
I saw this post from 3 years ago regarding converting DOUBLE values to
CHAR in ibm DB2. Now I'm having the same problem. No real solution
was posted to that old thread. Has anyone got...
|
by: Scott |
last post by:
How do I convert the contents of a textbox to a double for mathmateical
operations? I'm using a form to collect values and when the user clicks OK,
the vlaues are used for calcualtions... but they...
|
by: Tor Aadnevik |
last post by:
Hi,
I have a problem converting values from Single to double.
eg. When the Single value 12.19 is converted to double, the result is
12.1899995803833.
Anyone know how to avoid this?
Regards...
|
by: Dilip |
last post by:
Recently in our code, I ran into a situation where were stuffing a
float inside a double. The precision was extended automatically
because of that. To make a long story short, this caused...
|
by: Ron |
last post by:
I want to calculate the surface area of a sphere from an inputed radius
with option strict on. I guess I am not converting something
correctly.
Here is what I am doing:
I have a textbox...
|
by: RG |
last post by:
I am reading in from a serial port a 16 bit number from 0 to 65536. It
is being read as a string from my microcontroller into VB using DEC5
or 5 digits are displayed. I need to display this value...
|
by: Blasting Cap |
last post by:
I keep getting errors that pop up when I am trying to convert an
application from dotnet framework 1.1 to framework 2.0. The old project
was saved in sourcesafe from Visual Studio 2003, and I have...
|
by: sparks |
last post by:
After changing all the variables in a table from long to double.
you get 9.1====becomes==== 9.19999980926514
ok I checked microsoft and they had a workaround.
export the values to excel...then...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new...
| |
