In article <MPG.211951b1631c501998968c@xxxxxxxxxxxxxxxxxxxx>,
jim@xxxxxxxxxxxxx says...
I'm coding my first web site using a mysql
database and DBI.
I can fetch records from the database
with no problem, but I'm having trouble
testing NULL values. If I load the value
of a date field into a variable ($dateadded),
how should the IF condition be written?
if (!defined $dateadded) works perfectly!
Note that, if what you want to do is filter out records for which a certain
field is NULL, you're probably better off doing that in your SQL, with an
IS NOT NULL clause in your conditional:
SELECT foo, bar FROM baz WHERE foo IS NOT NULL
AND bar >= 30
Re: Locking a database ...bar), including disabling Access Special Keys.... also suggest you convert your *Frontend* database to an mdE ... this will protect form, reports, and standard modules from ... (microsoft.public.access.forms)
Re: Access Runtime 2003 & 2007 ... Using Access 2003, open your legacy database.... You must select a menu bar.... Clear the Allow Built-in Toolbars check box, click OK, and then close ... Tony Toews, Microsoft Access MVP... (microsoft.public.access.setupconfig)
Re: ADABAS vs IMS vs DB2 Who is faster? ... you can "wonder" like most people do in a bar but you must have ... concluded that people make decisions about Database Software emotionally... ... Eventually IBM plays the "fear" factor as can be seen in the politics of the day. ...ADABAS vs IMS vs DB2 Who is faster? ... (bit.listserv.ibm-main)
Re: Semi-OT: With ID swipe, Big Brother bellies up to the bar ... club or patronizing any other bar or night club that practices swiping... driver's licenses.... It relies on trusting those doing the scanning, and trusting the competence/experience of those who wrote the database code.... (alt.guitar)
Re: How does this file know where to connect ... Try holding the Shift key down when you open the database.... If you right click on the menu bar,... connect to the database in SQL server instead to File B. ... I try to view all the codes in Visual Basic view, ... (microsoft.public.access.modulesdaovba)
