Search DaniWeb - mysqlinsert

Data type mismatch in criteria expression 13 Years Ago by clausont …numberchildren, @countyid, @zipcoderange, @startday, @DaysCov)" 'Dim MySqlInsert As String = "INSERT INTO problemdefinition (client, memberage, spouseage….Closed Then MyCon.Open() cmd.CommandText = MySqlInsert cmd.ExecuteNonQuery() MyCon.Close() End If '… EmptyData Message When Data is There in Database View 12 Years Ago by clausont …numberchildren, @county, @zipcode, @deductible, @startcoverage)" 'Dim MySqlInsert As String = "INSERT INTO problemdefinition (client,memberage, )… Try MyCon.Open() cmd.CommandText = MySqlInsert cmd.ExecuteNonQuery() Catch ex As Exception… Re: Button Event in Gridview - Row Disappears 11 Years Ago by clausont … "delete from SelectionsWEB" Dim MySqlInsert As String = "INSERT INTO WEBs…Closed Then MyCon.Open() cmd.CommandText = MySqlInsert cmd.ExecuteNonQuery() MyCon.Close() End If… Re: converting array from mysql database into a different mysql table 15 Years Ago by Will Gresham If you are inserting a new row into the table, then you want to use the Insert not Update, take a look at [URL="http://www.tizag.com/mysqlTutorial/mysqlinsert.php"]this[/URL] Re: inserting data to mysql 12 Years Ago by IIM … doubt just click [URL="http://www.tizag.com/mysqlTutorial/mysqlinsert.php"]here[/URL] Re: Data type mismatch in criteria expression 13 Years Ago by propertywant I thought you had to put '#' around date fields [CODE] Add(New OleDbParameter("@startday", "CDate('#" + MyDate + "#')")) [/CODE] I could be wrong - been a long time since I did access Re: Data type mismatch in criteria expression 13 Years Ago by clausont Thanks for the try on this. I found the problem was that I had declared the textbox as a string rather than a date. Now I just need to figure out why I get no value given when the fields are all filled.... Thanks again. Re: EmptyData Message When Data is There in Database View 12 Years Ago by clausont No idea why but it is working now.