|
|
[q][i]Originally posted by: [b][b]Newsgroup User[/b][/b][/i]
It's difficult to tell without seeing your code.
[/q]
I'm not sure which portion you need, but here are some examples of the SQL
Inserts and Updates. They're pretty simple:
<cfquery name="PutRec" datasource="XXX">
INSERT INTO XXXLoad
( CRef,Amount,CName,CommRate,IntRate )
VALUES
( '#fileno#',#amt#,'#name1#','#thecommrate#','#theintrate#' )
</cfquery>
<cfquery name="PutXXX" datasource="XXXData">
INSERT INTO XXXData
( FileNo,FFile,MFile,FID,FmID,CType,FDate,CName,Comm,IntRate )
VALUES
(
'#fileno#','#ffile#','#mfile#','#fid#','#fmid#','#ctype#','#xfdate#','#name1#','
#comm#','#intrate#' )
</cfquery>
<cfquery name="UpdRec2" datasource="XXX">
UPDATE xxxload
SET dname = '#dname#', address1 = '#addr1#', city = '#dcity#', state =
'#dstate#',
zip = '#dzip#', dphone = '#dphone#', ssn = '#Trim(dssn)#', dob =
'#thedob#',
status = '#astatus#'
WHERE cref = '#fileno#'
</cfquery>
<cfquery name="UpdXXX6" datasource="XXXData">
UPDATE xxxdata
SET dno = '#dno#', batchid = '#batchid#', batchno = '#batchno#', cid =
'#cid#',
pid = '#pid#', gp1 = '#gp1#', gp2 = '#gp2#', gp3 = '#gp3#', gp4 =
'#gp4#',
gp5 = '#gp5#', gp6 = '#gp6#', officenum = '#officenum#'
WHERE fileno = '#fileno#'
</cfquery>
|
|