Hello once again,
I am trying to run a query against Oracle using PHP but I keep getting an error when I try to use a date in the query. Here is my code:
<?php
///////////////////////////
// Oracle Connect String //
//////////////////////////
//PutEnv("ORACLE_SID=TST");
//PutEnv("ORACLE_HOME=C:\oracle\ora92");
//PutEnv("TNS_ADMIN=C:\oracle\ora92\network\admin");
$conn = OCILOGON("apps", "apps", "DEV");
////////////////////////
// End Oracle Connect //
///////////////////////
//$P_EXP_RNG_LOW = DATE(2004-01-04);
//$P_EXP_RNG_HIGH = DATE(2004-05-04);
$stmt = OCIParse($conn,
"SELECT
TRIM(d.cust_code) CUST_CODE,
TRIM(e.name) CUST_NAME,
TRIM(b.proj_code) PROJ_CODE,
TRIM(d.proj_name) PROJ_NAME,
TRIM(b.price_plant_code) PLNT_CODE,
TRIM(b.prod_code) PROD_CODE,
TRIM(c.descr) ITM_DESC,
b.price PROJ_PRICE,
TRIM(a.loc_code) LOC_CODE,
a.price LIST_PRICE,
TRIM(f.comp_code) COMP_CODE,
TRIM(G.NAME) SALES_REP
FROM
IPRC@cmdp a,
prjp@cmdp b,
imst@cmdp c,
PROJ@CMDP d,
cust@cmdp e,
plnt@cmdp f,
empl@CMDP G
WHERE
a.loc_code = b.price_plant_code
and a.item_code = b.prod_code
and c.item_code = a.item_code
and b.proj_code = d.proj_code
and d.cust_code = e.cust_code
and f.comp_code in ('001', '100','103','106')
and f.plant_code = b.price_plant_code
and d.CA_SLSMN_EMPL_CODE = g.EMPL_CODE
and d.EXPIR_DATE >= '2005/01/11'
and d.EXPIR_DATE <= '2005/05/11'
ORDER BY
e.name,
d.proj_name,
TRIM(b.prod_code),
b.price_plant_code,
a.price,
b.price,
g.EMPL_CODE");
OCIExecute($stmt);
while (OCIFetchInto ($stmt, $col_id, OCI_ASSOC))
{echo $col_id['CUST_NAME']; echo "<BR>";}
OCILogoff($conn);
When I try to run this script I get the following error:
Warning: ociexecute() [function.ociexecute]: OCIStmtExecute: ORA-01861: literal does not match format string ORA-02063: preceding line from CMDP in c:\inetpub\wwwroot\dev\Reports\LVYCMDPIR.php on line 64
