RE: NULL insertion

2003-02-24 Thread Scot Robnett
This assumes MySQL is your DB. I know there are other people on this list that can offer more efficient solutions or pick this one apart...so feel free. :) *** #!/usr/bin/perl use strict; use CGI qw(:all); use CGI::Carp qw(fatalsToBrowser); use

Re: NULL insertion

2003-02-24 Thread Dennis Stout
> I need to insert NULL into the database using a perl CGI . So if a variable > is to be made NULL in perl and it needs to be used in an sql statement what > is best way to do it. Do I assign ' \N' to it or 'NULL' ? Standard SQL syntax for presenting null is SET VARIABLE=NULL, but I'd need to know

NULL insertion

2003-02-24 Thread T. Murlidharan Nair
Hi!! I need to insert NULL into the database using a perl CGI . So if a variable is to be made NULL in perl and it needs to be used in an sql statement what is best way to do it. Do I assign ' \N' to it or 'NULL' ? Thanks and Cheers always!! Murli -- To unsubscribe, e-mail: [EMAIL PROTECTED] Fo

Re: php like behavior for my perl CGI

2003-02-24 Thread Todd W
f'ups rearranged > > [EMAIL PROTECTED] wadet]$ perl > > sub box { > > return(''); > > } > > print < > > > > > ${\box(5,10)} > > ${\box(7,10)} > > > > > > eot > > Ctrl-D > > > > > > > > > > > > > > > > see: > > > > [EMAIL PROTECTED] wadet]$ perldoc perlref "Pete

Re: MySQL won't GRANT ALL ON cookbook.* ... ERROR 1044

2003-02-24 Thread fliptop
On Sun, 23 Feb 2003 at 20:09, Ed Sickafus opined: ES:Server: Linux (RedHat 7.2) Apache 1.3.x ES:I'm trying to run an introductory exercise out of MySQL Cookbook by Paul ES:DeBois ES:Accessing MySQL from a PC via PuTTY to ISP's UNIX ES:I can get to the mysql> prompt but no further. [snip] since yo