get the sql statement

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance



How can I get the actual SQL statement rather than this sh@thole error?

Data type mismatch in criteria expression.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information
about the error and where it originated in the code.

Exception Details: System.Data.OleDb.OleDbException: Data type mismatch in
criteria expression.

Source Error:

Line 265: Protected Sub btnSave_Click(ByVal sender As Object, ByVal e As
System.EventArgs)
Line 266: saveImages()
Line 267: FormView1.InsertItem(True)
Line 268: End Sub
Line 269: Protected Sub btnPanel1Cancel_Click(ByVal sender As Object,
ByVal e As System.EventArgs)


.



Relevant Pages

  • Re: get the sql statement
    ... since it's a datatype mismatch - just look at the ... Data type mismatch in criteria expression. ... Protected Sub btnPanel1Cancel_Click(ByVal sender As Object, ...
    (microsoft.public.dotnet.framework.aspnet)
  • Error 3464 with dCount - some computers only
    ... Error 3464 - Data type mismatch in criteria expression" from this line ... and produces a recordset with 36 records ... this code (and the print in the immediate window) ...
    (microsoft.public.access.formscoding)
  • Re: Update query
    ... > It *should* set the value to NULL if the Allow Zero Length is false. ... Data type mismatch in criteria expression. ... Those are 2 single quotes... ...
    (microsoft.public.access.queries)
  • Re: sort report by year (weird format)
    ... its okay - i get the error "data type mismatch in criteria expression" ... can i use a query?) ... Marshall Barton wrote: ...
    (microsoft.public.access.reports)
  • >255 into excel?
    ... I need to insert more than 255 chars into an excelcolumn ... "Data type mismatch in criteria expression." ... ('VAFocus - ADH','Item cannot be found in the collection corresponding to ...
    (microsoft.public.inetserver.asp.db)