Re: Full-text searching with quoted bind variables

2006-11-28 Thread Visolve DB Team
ssage - From: "William Langshaw" <[EMAIL PROTECTED]> To: Sent: Wednesday, November 29, 2006 12:54 AM Subject: Full-text searching with quoted bind variables I am using Full-Text searching with In Boolean Mode. I am generating my query by using binding parameters. If a user typ

Full-text searching with quoted bind variables

2006-11-28 Thread William Langshaw
I am using Full-Text searching with In Boolean Mode. I am generating my query by using binding parameters. If a user types in a quoted string on the search form (in order to match that string as-is), the binding mechanism escape it with a backslash. The query runs fine and it appears to return the

Re: Cannot lock: called with 1 bind variables when 0 are needed

2004-10-24 Thread Jonathan Mangin
Wexler" <[EMAIL PROTECTED]> To: "Jonathan Mangin" <[EMAIL PROTECTED]> Sent: Sunday, October 24, 2004 4:53 PM Subject: Re: Cannot lock: called with 1 bind variables when 0 are needed Try this: my $sql = "LOCK tables TBUSR write, TBAUTH write, TBDATALOG write, TBAGCY

Re: Cannot lock: called with 1 bind variables when 0 are needed

2004-10-24 Thread Jonathan Mangin
Hmmm, you're probably right. I got carried away. - Original Message - From: "Mike Wexler" <[EMAIL PROTECTED]> To: "Jonathan Mangin" <[EMAIL PROTECTED]> Sent: Sunday, October 24, 2004 4:53 PM Subject: Re: Cannot lock: called with 1 bind variables

Cannot lock: called with 1 bind variables when 0 are needed

2004-10-23 Thread Jonathan Mangin
Hi all, With 3.23.38 I have: my $sql = "LOCK tables TBUSR write, TBAUTH write, TBDATALOG write, TBAGCY write, TBREL write, TBACCESSLOG write"; my $sth = $dbh->prepare($sql); $sth->execute($sql) || die "Cannot lock: " . $sth->errstr(); I get: Cannot lock: called wit

Re: Bind Variables.]

2003-01-24 Thread Gelu Gogancea
Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: "Alvaro Avello" <[EMAIL PROTECTED]> To: <[EMA

[Fwd: Bind Variables.]

2003-01-24 Thread Alvaro Avello
Hi everybody: I 'm actually having an problem trying to mygrate to mysql. it's true that mysql does not support bind variables ? . Actually the development in my company is over Centura team developer connected to Centura Sqlbase , and the code of the aplications is widely

Bind Variables.

2003-01-23 Thread Alvaro Avello
Hi everybody: I 'm actually having an problem trying to mygrate to mysql. it's true that mysql does not support bind variables ? . Actually the development in my company is over Centura team developer connected to Centura Sqlbase , and the code of the aplications is widely using bind

mysql bind variables in php

2001-12-27 Thread Henrik
Does anyone know if it’s possible to use any kind of bind variables to make the queries run faster. In perl I use; $sth=$dbh->prepare(”select * from table where name = ?”); $sth->execute(”Henrik”); Can I do it in PHP? Thanks /