Query / mySQL / Access

[John Smith]

Hi,

I've got a query that works fine when used in mySQL but completely fails
when I try to apply it to MS Access, weird thing is that it is just a copy
of a stored procedure that works fine in the same copy (with the
Request.QuerySt ring replaced by a fixed value) ! Any explaination would be
great, ID is a number BTW :

SELECT page_title,ID,p age_content FROM content WHERE ID='" &
Request.QuerySt ring("ID") & "' '

Had a look at aspfaq.com but couldn't find anything that applys.

Cheers

John

[TJS]

Re: Query / mySQL / Access

if ID is a number, why are you putting it inside single quotes ?


"John Smith" <john@nospam.sp am> wrote in message
news:bf938j$psn $1@sparta.btint ernet.com...[color=blue]
> Hi,
>
> I've got a query that works fine when used in mySQL but completely fails
> when I try to apply it to MS Access, weird thing is that it is just a copy
> of a stored procedure that works fine in the same copy (with the
> Request.QuerySt ring replaced by a fixed value) ! Any explaination would be
> great, ID is a number BTW :
>
> SELECT page_title,ID,p age_content FROM content WHERE ID='" &
> Request.QuerySt ring("ID") & "' '
>
> Had a look at aspfaq.com but couldn't find anything that applys.
>
> Cheers
>
> John
>
>[/color]