i guessed that as well but was confused as to why it was happening on the
varchars too!!
> -Original Message-
> From: Michael A. Chase [mailto:[EMAIL PROTECTED]]
> Sent: 16 February 2001 09:33
> To: [EMAIL PROTECTED]
> Cc: DBI Mailing List
> Subject: Re: problem
har and varchar2 fields
>
> > -Original Message-
> > From: Michael A. Chase [mailto:[EMAIL PROTECTED]]
> > Sent: 16 February 2001 09:20
> > To: Mark Zimmerman; [EMAIL PROTECTED]
> > Cc: [EMAIL PROTECTED]
> > Subject: Re: problems with bind params
&g
se [mailto:[EMAIL PROTECTED]]
> Sent: 16 February 2001 09:20
> To: Mark Zimmerman; [EMAIL PROTECTED]
> Cc: [EMAIL PROTECTED]
> Subject: Re: problems with bind params
>
>
> Mark: No. That would compare surname to a literal '?', not to the value
> he's supplying to
---
From: "Mark Zimmerman" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, February 16, 2001 4:46 AM
Subject: Re: problems with bind params
> try using single quotes around your variable in your sql statement
> > > > $sql=&qu
ROTECTED]>
Cc: "DBI Mailing List" <[EMAIL PROTECTED]>
Sent: Friday, February 16, 2001 4:38 AM
Subject: RE: problems with bind params
> No... its a varchar2(30).
> but it does also happen on a char field if i use the key field on
that
> table 'person_no' cha
ary 2001 15:21
> To: [EMAIL PROTECTED]; DBI Mailing List
> Subject: Re: problems with bind params
>
>
> Is surname a CHAR field?
>
> --
> Mac :})
> ** I normally forward private database questions to the DBI mail lists. **
> Give a hobbit a fish and he'll eat fish fo
Is surname a CHAR field?
--
Mac :})
** I normally forward private database questions to the DBI mail lists. **
Give a hobbit a fish and he'll eat fish for a day.
Give a hobbit a ring and he'll eat fish for an age.
- Original Message -
From: "Pete Coales" <[EMAIL PROTECTED]>
To: "DBI Maili