retrieve data from access database

[sicohne]

I have a table in an access database containing all long integers. Trying to retrieve the data brings up the error "data type mismatch in expression". The retrieval code is as follows

Dim da5 As New OleDbDataAdapter("SELECT * FROM Charges WHERE lowamount <'" & CLng(AmountBox1.Text) & "'", cn)

Am I missing something obvious?

 

[SqueakinSweep]

Dim da5 As New OleDbDataAdapter("SELECT * FROM Charges WHERE lowamount <'" & AmountBox1.Text & "'", cn)

And even better than this...and far safer, use SQL Parameters!

Sweep
...if it works dont f*** with it

 

[chrissie1]

you don't need to add the single quotes for numeric values

Dim da5 As New OleDbDataAdapter("SELECT * FROM Charges WHERE lowamount <" & AmountBox1.Text , cn)

and like he said


And even better than this...and far safer, use SQL Parameters!
And even better than this...and far safer, use SQL Parameters!
And even better than this...and far safer, use SQL Parameters!
And even better than this...and far safer, use SQL Parameters!
And even better than this...and far safer, use SQL Parameters!
And even better than this...and far safer, use SQL Parameters!
And even better than this...and far safer, use SQL Parameters!


Christiaan Baes
Belgium

If you want to get an answer read this FAQ faq796-2540
There's no such thing as a winnable war - Sting

 

[SqueakinSweep]

Whoops...I forgot to take the single quotes off.

Sweep
...if it works dont f*** with it

 

[sicohne]

Thanks for that.

I'm fairly new to this and have no idea what you mean by SQL parameters (time for a google search I guess).