Insert value into database error

#1


How to solve this error.

0 Likes

#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

0 Likes

#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

0 Likes

#4

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

0 Likes

#5

@Madhavi ok. I will try

0 Likes

#6

@Madhavi
After removing " I got following error

0 Likes

#7

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

0 Likes

#8

schema

0 Likes

closed #9
0 Likes