inserts into SQL 2000 Dates and Nulls

Dates and Nulls formating issues

[Dart]

I have an issue with the formating of date fields. SQL2000 requires the a date to be inside single quotes. I am trying to use an if statement to validate Null and date fields:

if ($FORM{TX_DT})
{
&datechecks($FORM{TX_DT}, 'TX');
$TX_DT = $FORM{TX_DT};
}
else
{
$TX_DT = NULL;
}
I need the correct way to put the value $FORM{TX_DT} in single quotes.

also can anyone tell me the best way to test the scripts I am very new with this.

Thanks

[jatar_k]

Welcome to WebmasterWorld Dart,

wouldn't this work?

$TX_DT = "'" . $FORM{TX_DT} . "'";

[Dart]

thanks,

that is correct It works.

[phranque]

welcome to WebmasterWorld, dart!