Re: Hacker prevention

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

Bob Barrows wrote:
MikeR wrote:
UPDATE Stations SET rigs = [RIG], AMPS = iif([P2] = "" , [AMPS],[P2])
WHERE call=[UCALL];

Running this in the query designer blanks the column AMPS if P2 is
left blank. If it's filled, it works as expected.

Are you making sure to pass an empty string if the user leaves it blank?

<slapforehead strength="hard">DOH!</slapforehead> Nope, I was just clicking OK on the dialog box in Access. Entering "" worked.
.

Relevant Pages

  • Re: Hacker prevention
    ... MikeR wrote: ... Running this in the query designer blanks the column AMPS if P2 is ... Bob Barrows ...
    (microsoft.public.inetserver.asp.db)
  • Re: Hacker prevention
    ... Bob Barrows wrote: ... Running this in the query designer blanks the column AMPS if P2 is ... Are you making sure to pass an empty string if the user leaves it ...
    (microsoft.public.inetserver.asp.db)