How to query for an apostrophe

Hiya. How can I search for the following?: D'Silva If I try to search for it, with the following query string: SELECT * FROM Players WHERE LName LIKE `%D'Silva%` I get the following error: Died while executing:[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1. (SQL-0700

RE: X case-insensitivity in Access

RE: X case-insensitivity in Access > > > Try > > SELECT * FROM People WHERE LName like 'hoff%' > > no % before hoff ( assuming it starts with hoffman, hoffroy, > hoffsomething, > hoffanything..) and use single quotes > it shuld match. > > u

X case-insensitivity in Access

Nick Hoffman > -----Original Message- > From: Nick Hoffman [UWO] [mailto:[EMAIL PROTECTED]] > Sent: August 9, 2002 6:06 PM > To: DBI-Users > Subject: case-insensitivity in Access > > > Hey. I'm using an Access2000 DB. I have the following

case-insensitivity in Access

Hey. I'm using an Access2000 DB. I have the following information in a table called People: Jones Hoffman Offman Smith How can I select everything that contains "off", regardless of capitalization? (ie: select Hoffman and Offman with just "off") The following retu

RE: zero-length string

002 15:16:18 -0400, Nick Hoffman [UWO] wrote: > > >I'm trying to insert into a table where only 3 fields (1 being > the primary > >key) are required, yet I get the following error when I execute: > > > >--- > >Died while executing: > &g

RE: zero-length string

> Sent: July 30, 2002 3:23 PM > To: DBI-Users > Subject: Re: zero-length string > > > On Tue, 30 Jul 2002 15:16:18 -0400, Nick Hoffman [UWO] wrote: > > >I'm trying to insert into a table where only 3 fields (1 being > the primary > >key) a

zero-length string

I'm trying to insert into a table where only 3 fields (1 being the primary key) are required, yet I get the following error when I execute: --- Died while executing: [Microsoft][ODBC Microsoft Access Driver] Field 'Volunteers.Email' cannot be a zero-length string. (SQL-S1000)(DBD: st_

Data type mismatch in criteria expression

Hiya. I'm using Access2000 and DBI::ODBC. I'm trying to insert into a table called Volunteers, and I continually get this error: -- Died while executing:[Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression. (SQL-22005)(DBD: st_execute/SQLExecute err=-1)

module/function to export to Excel?

Hiya. I'm using DBD::ODBC and an Access2000 database. Is there a module or function that can export an Access2000 database to an Excel spreadsheet? If so, would someone mind pointing me in the right direction? Thanks! Nick Hoffman

problem inserting

Hiya. On my home comp, I'm able to insert into my Players table perfectly. I uploaded my scripts and DB to my domain, try to insert, and get the following error: Content-type: text/html Software error: Died while executing: [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateabl

RE: need execute perms?

Day > Words & Images > Toronto, Canada > > > > At 11:07 AM 6/24/2002 -0400, Nick Hoffman [UWO] wrote: > >Hi. The hosting company that I am with says that you only need > "execute for > >scripts" permissions to run Perl scripts in my cgi-bin

need execute perms?

Hi. The hosting company that I am with says that you only need "execute for scripts" permissions to run Perl scripts in my cgi-bin directory. However, I'm unable to run *any* of my scripts. Might anyone know why that may be? Whenever I try to, I get a 403.1 Forbidden: Execute Access Forbidden. The