Joe,
I have seen that forum, but the solutions mentioned doesnt help me.
Adding this: SET sql_mode=''
to my procedure doesnt seem to work (James C. Sanders) and I don't
want to reinstall 5.1.23 or install 5.1.22 (Mike Nol).
This is really bugging me... ok, i added the "myDataSet.Tables
("table1"). The page still works, and it makes no difference. I guess
I will keep it there for now.
The columns of table1 are called: ID, part_no, customer, cust_part_no,
cust_code.
The first row of table1: 1, partno1, customer1, custpartno1,
custcode1
The so the other rows follow the same pattern.
Just now, I realised that the single line of data outputed on the
asp.net page is not the data itself but the headings of the columns.
I think this is a control problem, because when I change the following
line
Using myDA As New MySqlDataAdapter("SELECT part_no, cust_part_no,
customer FROM table1 WHERE part_no LIKE" & "'%...@input_part_no
%'",myConnection)
to:
Using myDA As New MySqlDataAdapter("SELECT part_no, cust_part_no,
customer FROM table1 WHERE part_no LIKE '%partno%'", myConnection)
i.e., I hardcode and don't use parametized statements, the result on
my asp.net page is correct. It outputs all the 13 rows of data as well
as the heading row.
So I guess its something to do with the parametized statement, maybe
@input_part_no is not taking the string given by the user in the
search box.
Thanks for taking time to understand my situation. =)
Helvin
