Re: Error: Data type mismatch in criteria expression

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Steven Burn (somewhere_at_in-time.invalid)
Date: 01/03/05 

Date: Mon, 3 Jan 2005 23:07:07 -0000

If IsNull(TheValue) Then TheValue = 0
'// code to update the DB 

--
Regards
Steven Burn
Ur I.T. Mate Group
www.it-mate.co.uk
Keeping it FREE!
"Jack" <Jack@discussions.microsoft.com> wrote in message
news:95AE6050-A5DE-416C-8AE6-101D9DA02622@microsoft.com...
> Hi,
> I have posted this problem before. Apprently, the suggestion took care of
> the problem. However, still I am getting the above error message.
> I am using a session variable to transfer a value from a form to a
> confirmation.asp page. This value is a calculated field. For most cases
this
> session variable value should be zero. However, instead, it is giving null
> value and this null value is messing up the update statement which is
> supposed to update the table in the database. This session variable value
> being null is trying to update a currency field which gives the above
error.
> The sql statement via response.write is as follows:
> UPDATE tblGMISExpenditures_Quarter SET
> tblGMISExpenditures_Quarter.CurrentOutlay= '$0.00' ,
> tblGMISExpenditures_Quarter.LocalShare= '$0.00' ,
> tblGMISExpenditures_Quarter.MBCCShare= '' ,
> tblGMISExpenditures_Quarter.UnpaidOblig= '$0.00' ,
> tblGMISExpenditures_Quarter.LocalShareUnpaidOblig= '$0.00' ,
> tblGMISExpenditures_Quarter.ProjectIncome= '$0.00' ,
> tblGMISExpenditures_Quarter.ForfeitureIncome= '$0.00' ,
> tblGMISExpenditures_Quarter.OtherExpense= '$0.00' ,
> tblGMISExpenditures_Quarter.ForfeitureExpense= '$0.00' ,
> tblGMISExpenditures_Quarter.InterestReceived= '$0.00' ,
> tblGMISExpenditures_Quarter.TotalPeriodOutlay= '' ,
> tblGMISExpenditures_Quarter.Remarks= ' ' ,
tblGMISExpenditures_Quarter.Name=
> ' ' , tblGMISExpenditures_Quarter.Title= ' ' ,
> tblGMISExpenditures_Quarter.AreaCode= ' ' ,
> tblGMISExpenditures_Quarter.Phone1= ' ' ,
tblGMISExpenditures_Quarter.Phone2=
> ' ' , tblGMISExpenditures_Quarter.Date= '1/3/2005' where
> tblGMISExpenditures_Quarter.SubgrantIntID = 6032;
> Any help or alternative to use a calculated field(not user input field) to
> update a database is appreciated. Thanks.
>
>

Relevant Pages

  • Error: Data type mismatch in criteria expression
    ... still I am getting the above error message. ... This value is a calculated field. ... value and this null value is messing up the update statement which is ... supposed to update the table in the database. ...
    (microsoft.public.inetserver.asp.general)
  • Re: Error: Data type mismatch in criteria expression
    ... few fields that are input by user, while there is one calculated field based ... "Steven Burn" wrote: ... still I am getting the above error message. ... >> supposed to update the table in the database. ...
    (microsoft.public.inetserver.asp.general)
  • Re: DBD::Informix 2003.04 AIX4.3.3 SELECTIVE TEST ERRORS
    ... one which you could fix by removing the database). ... The bug report is below. ... > Informix Server Entries in sqlhosts file ... > # Error Message: ...
    (perl.dbi.users)
  • Re: Module Not Found
    ... Close the database. ... Still in the code window, choose Compile from the Debug menu. ... The error message could be related to something else that is going on, ... VB and press the cancel button I receive the error message ...
    (microsoft.public.access.formscoding)
  • Re: Cannot open my own Databases
    ... Windows Administrator and loads each of these service packs. ... If I have guessed correctly about the error message you see, ... See http://www.QBuilt.com for all your database needs. ... it's possible that the correct workgroup information file ...
    (microsoft.public.access.security)