RE: FW: thanks

i've found from my own experience that it's better to stay away from
cfupdate and cfinsert and just write the SQL query. you'll have more
control and it's less likely to break if you alter your db or your code
later on.

> -----Original Message-----
> From: dwiese@xxxxxxxxxxxxx [mailto:dwiese@xxxxxxxxxxxxx]
> Sent: Thursday, July 13, 2000 1:16 PM
> To: azcfug-VgYJa0VH1e9BDgjK7y7TUQ@xxxxxxxxxxxxxxxx
> Subject: Re: [azcfug] FW: thanks
>
>
>
> I agree that the new field in the REQUEST table is the best way to go. I
> am having a problem getting the variable to update that new
> field, I called
> ASSIGN.
>
> My form for making the assignments, inserts a new record, made up of data
> queried from the REQUEST table and INPUT from a form. I pass those
> parameters off to a new cfm to INSERT into a table called STATUS, where
> or how do I get a variable to pass to the REQUEST table to UPDATE
> the field
> ASSIGN with the value YES. My question is how can I INSERT into one table
> and UPDATE another from the same form or can I? I have tried just passing
> the variable to the cfm with:
>
> <FORM ACTION="addnew.cfm?Assign=YES" METHOD="POST">
>
> That doesn't seem to work. I even tried:
>
> <FORM ACTION="addnew.cfm" METHOD="POST"><INPUT type="hidden"
> name="ASSIGN" value="YES">
>
> That didn't seem to work either.
>
> This is the statement I used in addnew.cfm for insert and update:
>
> <CFINSERT
> DATASOURCE="Survey Status"
> TABLENAME="status"
> FORMFIELDS="Receiver, Received, Requestor, CostCode, ProjectNo,
> GrpNo, T, N, R, E, ProjectName, Specials, Assignments,
> SupAssignments, Surveyor">
>
> <CFIF IsDefined("assign")>
> <CFUPDATE DATASOURCE="Survey Status"
> TABLENAME="request" FORMFIELDS="Assign">
> </CFIF>
>
>
> ------------------------------------------------------------------------
> Get a NextCard Visa, in 30 seconds!
> 1. Fill in the brief application
> 2. Receive approval decision within 30 seconds
> 3. Get rates as low as 2.9% Intro or 9.9% Fixed APR
> http://click.egroups.com/1/6631/13/_/_/_/963522961/
> ------------------------------------------------------------------------
>
> To unsubscribe from this group, send an email to:
> azcfug-unsubscribe-VgYJa0VH1e9BDgjK7y7TUQ@xxxxxxxxxxxxxxxx
>
>