Insert value into database error


#1


How to solve this error.


#2

@swapnali1

The arguments you specified in the query should exactly match the Parameters you pass both in name and datatype.
For the query,
Update PurchaseOrderLineItems Set Status = @paramStatus where ID=@paramID


#3

hi @Madhavi Thank you for solution it’s worked.Will you tell me how to dump this data into database. In my database table wrong values are inserted. I want to enter diffrent values.
Following is my query

“INSERT Into dbo.FlipkartData
([Names],[Numbers],[Ratings])
VALUES
(’@Names’, ‘@Numbers’, ‘@Ratings’)”

My table is like below

But I want insert scraped data into database scraped data is in excel file.sample1.xlsx (9.1 KB)

following is my code structure
flipkartDataToMySql.xaml (17.9 KB)
will you please help me


#4

@swapnali1 remove ‘’ from your parameters.
"Insert into FlipkartData ([Names],[Numbers],[Ratings]) VALUES (@Names, @Numbers, @Ratings)”


#5

@Madhavi ok. I will try


#6

@Madhavi
After removing " I got following error


#7

Can you please add your table schema and a screenshot displaying the parameters you are passing?


#8

schema