how to insert a blank field in a date field

I'am parsing a text field delimited by ; (see example belown). I split the file into multiple variable ($) and then execute the request. When the NO is blank: no problem the record is write inside DB but when de DATE is blank I receive a message from DB telling me that the format of the date is

FreeBSD only issue with fetchall_arrayref?

Hi, I can't figure out what could be causing this, but I am pretty certain that it is a Freebsd related to DBI issue. I have FreeBSD 4.5 stable, mysql 4.0.1, DBI 1.30 both installed from ports, and DBD::mySQL 2.0416 The problem is when I use fetchall_arrayref the last column is empty. for

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 returns

RE: case-insensitivity in Access

Hi Nick, Try something like this: SELECT * FROM people WHERE UPPER(lname) LIKE '%OFF%'; Good luck. -John -Original Message- From: Nick Hoffman [UWO] [mailto:[EMAIL PROTECTED]] Sent: Friday, August 09, 2002 3:06 PM To: DBI-Users Subject: case-insensitivity in Access Hey.

X case-insensitivity in Access

Hi. Apologies for my bad. SELECT * FROM People WHERE LName LIKE %off% DOES return Hoffman and Offman. How can I search for Hoffman with hoff? ie: SELECT * FROM People WHERE LName like %hoff% Doesn't return Hoffman. Any ideas? Thanks, Nick Hoffman -Original Message-

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. urmil -Original Message- From: Nick Hoffman [UWO] [mailto:[EMAIL PROTECTED]] Sent: Friday, August 09,

RE: X case-insensitivity in Access

What about matching 'hoff' in the middle? Such as: Smith-Hoffman Thanks, Nick -Original Message- From: Shah, Urmil [mailto:[EMAIL PROTECTED]] Sent: August 9, 2002 6:24 PM To: '[EMAIL PROTECTED]'; DBI-Users Subject: RE: X case-insensitivity in Access Try

RE: X case-insensitivity in Access

SELECT * FROM People WHERE LName like '%hoff%' then use % before hoff and it will match hoff anywhere in the string(LName) Urmil -Original Message- From: Nick Hoffman [UWO] [mailto:[EMAIL PROTECTED]] Sent: Friday, August 09, 2002 5:34 PM To: Shah, Urmil; DBI-Users Subject: RE: X

RE: request for DBD::Changes change (and possible bug)

-Original Message- From: Ted Thibodeau Jr [mailto:[EMAIL PROTECTED]] Sent: Friday, August 09, 2002 6:16 PM To: [EMAIL PROTECTED] Subject: request for DBD::Changes change (and possible bug) Hi there -- I'm trying to track down a possible bug (might be in DBD::ODBC, might be in

New version of DBD::ODBC

Fix for building with iODBC (which didn't have SQLAllocHandleStd). The uploaded file DBD-ODBC-0.45_13.tar.gz has entered CPAN as file: $CPAN/authors/id/J/JU/JURL/DBD-ODBC-0.45_13.tar.gz size: 77057 bytes md5: 52d4a4c74e568547648e6ed766df0615 No action is required on your part