Usually I build my queries dynamically.
I store all the values into a hash ( this is in perl mind you.. )
Then do something like this..
my (@fields, @vals);
my ($field_str, $val_str);
foreach $field_name (keys %hash)
{
if ($hash{$field_name})
{
push @fields, $fie
Thank you for the information. Let me please clarify that i am using a
web form. I tried the one solution of converting those values that are
not set to null, but mysql complained:
SQL: INSERT INTO
Development_Event_Show(showID,venueID,description,ageCutoff,ageDelimiter,price1,price2)
VALU
On Friday 12 April 2002 8:10 pm, Carl Schmidt wrote:
> I have a form where a user enters some numbers into text boxes. Some of
> the text boxes can be left blank. The business logic receives all
> variables to all text boxes. Should I :
I'm assuming that you are using an executable file and NO
I have a form where a user enters some numbers into text boxes. Some of
the text boxes can be left blank. The business logic receives all
variables to all text boxes. Should I :
1.) Validate on the page for the presence of a value, and if not, set the
corresponding value to -1 (it will never b
