Posted by [IP Address: 12.109.131.69] 'LeAnne Smith' on August 31, 2001 at 10:46:14 EST:
In Reply to: Re: Help Inserting into PS_PERSON_COMMENT posted by [IP Address: 12.109.131.69] 'Invisible_Man' on August 31, 2001 at 10:32:29 EST:
: What database platform are you on?
On Oracle, thanks ,
here is the actual insert code
begin-sql
INSERT INTO PS_PERSON_COMMENT (
EMPLID,
COMMENT_DTTM, ! error here !
ADMIN_FUNCTION,
CMNT_CATEGORY,
DEPTID,
CMNT_ID,
ACAD_CAREER,
STDNT_CAR_NBR,
ACAD_PLAN,
ACAD_PROG,
STRM,
AID_YEAR,
CAMPUS_EVENT_NBR,
EVENT_MTG_NBR,
ADM_APPL_NBR,
BUSINESS_UNIT,
CASHIER_OFFICE,
COLLECTION_ID,
CONTRACT_NUM,
GROUP_ID_SF,
INVOICE_ID,
ITEM_NBR,
LINE_SEQ_NBR,
PAYMENT_ID_NBR,
RECEIPT_NBR,
REFUND_NBR,
APPL_PROG_NBR,
EFFDT_VAR,
EFFSEQ_VAR,
ITEM_TYPE,
ACCOUNT_NBR,
ACCOUNT_TERM,
CHECKLIST_DTTM_VAR,
LOAN_TYPE,
LN_APPL_SEQ,
RESTRICTED_AID_ID,
SESSION_NO,
GIFT_NO,
RECOGNITION_TYPE,
DESIGNATION,
INTV_CD,
AV_AUDIENCE,
AUD_TYPE,
MEMBERSHIP_NBR,
AV_MBR_ORG_COD,
AV_STD_BEN,
MBR_PMT_NO,
INSTITUTION,
COMMENTS)
VALUES (
$emplid, ! emplid
$cmnt_dttm, ! i tried $cmnt_dttm =$asoftoday,
SYSDATE, hard coded value for date
no use ......
$admin_function, ! admin function
$cmnt_category, ! cmnt category
' ', ! dept id
'0319020', ! cmnt id
'ABC', ! acad_career
'0', ! stdnt car nbr
' ', ! acad plan
' ', ! acad prog
' ', ! strm
'0', ! aid_year
' ', ! campus evnt nbr
'0', ! event mtg nbr
' ', ! adm appl nbr
' ', ! business unit
' ', ! cashier office
'0', ! collection id
' ', ! contract num
' ', ! group id sf
' ', ! invoice id
' ', ! item nbr
'0', ! line seq nbr
'0', ! payment id nbr
'0', ! receipt nbr
'0', ! refund nbr
'0', ! appl prog nbr
' ', ! effdt var
'0', ! effseq var
' ', ! item type
' ', ! account nbr
' ', ! account term
' ', ! chklist dttm var
' ', ! loan type
'0', ! ln appl seq
' ', ! restricted id
' ', ! session no
' ', ! gift no
' ', ! recognition type
' ', ! designation
' ', ! intv cd
' ', ! aud
' ', ! aud type
' ', ! membership nbr
' ', ! av mbr org cod
' ', ! av std ben
' ', ! mbr pmt no
'MYME', ! institution
$otherdesc); ! comments
end-sql