Re: FN-FORUM ASP opportunity

date posted 29th September 2002 18:46

No flowers, no chocolates, the code clinched it for Andy and John:)
I'm off to buy a hat
Carla

on 29/9/02 4:29 pm, john anslow at [EMAIL REMOVED] wrote:

> Andy,
>
> I love you, thanks!
>
> John
>
> Andy Stafford wrote:
>
>> This is what I use for Access. Causes me no trouble. Obviously it doesn't
>> need to be in a function, but I copied it from an include file just as an
>> example.
>>
>> HTH
>>
>> Andy
>>
>>
>>
>> dim gobjCmd
>>
>> set gobjCmd=gCreateConnection
>>
>>
>> strSQL="UPDATE client_emails set viewed=true where client_id=1"
>> gobjCmd.CommandText=strSQL