error 80040e14

Results 1 to 2 of 2

Thread: error 80040e14

  1. #1
    tiago mateus Guest

    Default error 80040e14

    I keep getting the following error: <BR><BR>Microsoft JET Database Engine error &#039;80040e14&#039; <BR><BR>The SELECT statement includes a reserved word or an argument name that is misspelled or missing, or the punctuation is incorrect. <BR><BR>/postcard/inccard.asp, line 109 <BR><BR>when what is written on the line is:<BR><BR>Function PostCard_GetCatCount()<BR> Dim oRS<BR> <BR> Set oRS = Postcard_GetDatabaseConn().Execute("SELECT Count(*) as No FROM cat" )<BR> PostCard_GetCatCount = oRS("No").Value<BR> oRS.Close <BR>End Function<BR><BR>What seems to be the problem?

  2. #2
    Join Date
    Dec 1969

    Default RE: error 80040e14

    No might mean something:<BR><BR>SELECT Count(*) as NoOfRecs FROM cat<BR>PostCard_GetCatCount = oRS("NoOfRecs").Value

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts