--=====================_5567455==_.ALT
Content-Type: text/plain; charset="us-ascii"; format=flowed
If you could use CFQUERY instead of CFUPDATE to update your data, simply
specify a WHERE clause that narrow enough the lines to be updated.
<CFQUERY NAME="qryname" DATASOURCE="maindsn">
UPDATE MYTABLE SET COL1=value1, COL2=value2, ...
WHERE COL_PARTIAL_ID1 = first_part_of_id AND COL_PARTIAL_ID2 =
rest_part_of_id
</CFQUERY>
>I'm sure it's possible, I just can't find it in the documentation.
See more on this Searching on CF Studio for this string: "Creating an
Action Page to Update Data"
At 11/21/2000 08:07 AM -0500, you wrote:
>Ok... yeah, that makes sense that a flat dbf wouldn't need a primary
>key... but then how do you make Cold Fusion think that there is a primary
>key so that I can do update and delete operations on the rows in the
>table?
>
>
>John Biesnecker
>[EMAIL PROTECTED]
>
>------------------------------------------------------------------------------
>To unsubscribe, send a message to [EMAIL PROTECTED] with
>'unsubscribe' in the body or visit the list page at www.houseoffusion.com
--=====================_5567455==_.ALT
Content-Type: text/html; charset="us-ascii"
<html>
If you could use CFQUERY instead of CFUPDATE to update your data, simply
specify a WHERE clause that narrow enough the lines to be updated.<br>
<br>
<CFQUERY NAME="qryname"
DATASOURCE="maindsn"><br>
<x-tab> </x-tab>UPDATE
MYTABLE SET COL1=value1, COL2=value2, ...<br>
<x-tab> </x-tab><b>WHERE
COL_PARTIAL_ID1 = first_part_of_id AND COL_PARTIAL_ID2 =
rest_part_of_id<br>
</b></CFQUERY><br>
<br>
<br>
<blockquote type=cite class=cite cite>I'm sure it's possible, I just
can't find it in the documentation.<br>
</blockquote><br>
See more on this Searching on CF Studio for this string: "Creating
an Action Page to Update Data"<br>
<br>
<br>
<br>
At 11/21/2000 08:07 AM -0500, you wrote:<br>
<blockquote type=cite class=cite cite>Ok... yeah, that makes sense
that a flat dbf wouldn't need a primary<br>
key... but then how do you make Cold Fusion think that there is a
primary<br>
key so that I can do update and delete operations on the rows in
the<br>
table?<br>
<br>
<br>
John Biesnecker<br>
[EMAIL PROTECTED]<br>
<br>
------------------------------------------------------------------------------<br>
To unsubscribe, send a message to [EMAIL PROTECTED]
with 'unsubscribe' in the body or visit the list page at
<a href="http://www.houseoffusion.com/" eudora="autourl">www.houseoffusion.com</a>
</blockquote></html>
--=====================_5567455==_.ALT--
------------------------------------------------------------------------------
To unsubscribe, send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body or visit the list page at www.houseoffusion.com
