Unable to query with parameter.

Question

User336673788 posted

Hi guys,

My have a column SerialNumber with Text as the datatype.

from my app, i'm able to insert record:

record 1 the serial#: 123456
record 2 the serial#: hello

 

within my app, i have a search for serial number: when i search for 123456, the record is found, but when i search for hello, it does not return anything. Both records are in the database.

 

Here's the Query:

cmd.commandtext = SELECT * FROM TOYS WHERE SERIALNUMBER = ?;

OleDbParameter param = new OleDbParameter("@SerialNumber", OleDbType.VarChar, 100);
param.value = argSerialNumber;

cmd.parameters.add(param);

return (string)executeScalar();

 

again, searching for 123456 works, but not the hello. any input is appreciated. 

Answer 1

User-2010311731 posted

Not sure why this would be a problem.  Did you try making sure both "hello" strings were trimmed and lower-case?

Matt

Answer 2

User336673788 posted

its all lower case. i copy and paste the string ... i know, it should work since it's text (string). how odd.

Answer 3

User-2010311731 posted

cmd.commandtext = SELECT * FROM TOYS WHERE SERIALNUMBER = ?;

Possibly try putting double-quotes around the ?...

cmd.commandtext = SELECT * FROM TOYS WHERE SERIALNUMBER = "?";

 

Matt

Answer 4

User336673788 posted

:p

okay, my bad. i have a custom function to validate the serialnumber "isNumeric". in the code ... hahaha, thank you. that's what you get for looking at the screen too long.