RE: problems with bind params

2001-02-16 Thread Pete Coales
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

Re: problems with bind params

2001-02-16 Thread Michael A. Chase
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

RE: problems with bind params

2001-02-16 Thread Pete Coales
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

Re: problems with bind params

2001-02-16 Thread Michael A. Chase
--- 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

Re: problems with bind params

2001-02-16 Thread Mark Zimmerman
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

RE: problems with bind params

2001-02-16 Thread Pete Coales
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

Re: problems with bind params

2001-02-14 Thread Michael A. Chase
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