Hi all ,
I'm trying to run a query from an access database . I'm using a date field
that is formatted like this mm/dd/yyyyy HH:MM:SS. I want to do a select with
a short date format to (mm/dd/yyyyy ) the code below is what I'm using, so
far I keep getting the error massage "count field incorrect".
Could someone help please.
Thanks for your help.
John
code
$sth_cus_serv = $DBH->prepare("
SELECT [Call Item Detail].CallID,
Format$(([Call Item Detail].[CDate]),'mm/dd/yyyy') AS Expr1, [Customer
Survey].ItemDesc2, [customer service].[cust state]
FROM [customer service] INNER JOIN ([Customer Survey]
INNER JOIN [Call Item Detail] ON [Customer Survey].ItemID = [Call Item
Detail].ItemID)
ON [customer service].CallID = [Call Item Detail].CallID
WHERE (((Format$(([Call Item Detail].[CDate]),'mm/dd/yyyy'))=#$Report_Date#)
AND (([customer service].[cust state])='$State'))
")|| die $DBH->errstr;
$sth_cus_serv->execute () || die $DBH->errstr;
while (($CallID,$CDate,$ItemDescription,$cust_state) =
$sth_cus_serv->fetchrow_array)
{
$CDate_temp=&UnixDate($CDate,"%m/%d/%Y ");
$CDate_temp = $CDate;
$ItemDescription_temp = $ItemDescription;
$cust_state_temp = $cust_state;
}
_______________________________________________
ActivePerl mailing list
[EMAIL PROTECTED]
http://listserv.ActiveState.com/mailman/listinfo/activeperl
