Having Problems With SQL Statement[ACCESS DB]

[Roy Danon]

Hi,
This is my SQL Procedure :

IFF(21 in(SELECT PageID FROM TBL_Trafic WHERE PageID=21), (UPDATE TBL_Trafic
SET Hits=Hits+1, BytesUsed=BytesUsed+1713, LastEntered=now() WHERE
PageID=21), INSERT INTO TBL_Trafic
(WebsiteID,PageID,Hits,BytesUsed,LastEntered) VALUES (1,21,1,1713,now()))


For some reason, I get the following error :

Microsoft JET Database Engine (0x80040E14)
Invalid SQL statement; expected 'DELETE', 'INSERT', 'PROCEDURE', 'SELECT',
or 'UPDATE'.
/Config.asp, line 151

What's the problem here?


Roy.

[Bob Barrows]

Roy Danon wrote:

> Hi,
> This is my SQL Procedure :
>
> IFF(21 in(SELECT PageID FROM TBL_Trafic WHERE PageID=21), (UPDATE
> TBL_Trafic SET Hits=Hits+1, BytesUsed=BytesUsed+1713,
> LastEntered=now() WHERE PageID=21), INSERT INTO TBL_Trafic
> (WebsiteID,PageID,Hits,BytesUsed,LastEntered) VALUES
> (1,21,1,1713,now()))
>
>
> For some reason, I get the following error :
>
> Microsoft JET Database Engine (0x80040E14)
> Invalid SQL statement; expected 'DELETE', 'INSERT', 'PROCEDURE',
> 'SELECT', or 'UPDATE'.
> /Config.asp, line 151
>
> What's the problem here?
>
>

Several problems here. Have you tested this query in Access? For one thing:
there is no such function as IFF.

When you test it in Access, you will see several other problems. Some of the
standouts:
1. you cannot use control-of-flow language in a Jet query.
2. you cannot batch sql statements in a single query

You have to do the control-of-flow stuff in the code that is calling the
queries.

Bob Barrows
Bob Barrows
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

[Roy Danon]

Thank You,

I think I will use a recordset to check number of records.



Happy Hanucah,
Roy.

"Bob Barrows" <reb01501@NOyahoo.SPAMcom> wrote in message
news:O8vigZXAEHA.2480@TK2MSFTNGP12.phx.gbl...

> Roy Danon wrote:

> > Hi,
> > This is my SQL Procedure :
> >
> > IFF(21 in(SELECT PageID FROM TBL_Trafic WHERE PageID=21), (UPDATE
> > TBL_Trafic SET Hits=Hits+1, BytesUsed=BytesUsed+1713,
> > LastEntered=now() WHERE PageID=21), INSERT INTO TBL_Trafic
> > (WebsiteID,PageID,Hits,BytesUsed,LastEntered) VALUES
> > (1,21,1,1713,now()))
> >
> >
> > For some reason, I get the following error :
> >
> > Microsoft JET Database Engine (0x80040E14)
> > Invalid SQL statement; expected 'DELETE', 'INSERT', 'PROCEDURE',
> > 'SELECT', or 'UPDATE'.
> > /Config.asp, line 151
> >
> > What's the problem here?
> >
> >

> Several problems here. Have you tested this query in Access? For one

thing:

> there is no such function as IFF.
>
> When you test it in Access, you will see several other problems. Some of

the

> standouts:
> 1. you cannot use control-of-flow language in a Jet query.
> 2. you cannot batch sql statements in a single query
>
> You have to do the control-of-flow stuff in the code that is calling the
> queries.
>
> Bob Barrows
> Bob Barrows
> --
> Microsoft MVP - ASP/ASP.NET
> Please reply to the newsgroup. This email account is my spam trap so I
> don't check it very often. If you must reply off-line, then remove the
> "NO SPAM"
>
>

[Unregistered]

How do you do this problem?
Name (1st 25 characters only) with the column heading 'Theatre-Name'
The concatenation of City (1st 10 characters only), a comma, a space, and State with the column heading 'Location'