updating database

[MoparMarc]

I posted this in the general dis part too but maybe this
is better place since it has to do with forms...

here is my problem I need to overcome.

I have a registration webpage which is a form. once
someone submits the information on that page and clicks
submit, I need the information to update a access database
which i have, .mbd file? I am using dreamweaver to create
my pages, and microsoft access table where the date needs
to go. It will be going on a 2000 NT server.

anyhelp or direction would be Great, Please E-mail me any
info;
[email]MoparMarc@hotmail.com[/email]

Thanks
MoparMarc

[binhtri]

When you do a SELECT on a database table, you can also get the record count
(i.e., queryName.RecordCount).

I was wondering if you can get the same value, or something similar, if I were
to perform an UPDATE? In other words ... can I confirm if the update was
sucessful, without having to do a select on that table?

[TA-Selene]

Unfortunately, this won't work. You will need to do the select first and do the update if results are returned, otherwise do your insert.

[binhtri]

Well ... that's a bummer. Was hoping I could avoid tapping the db. Regardless, thanks Team Macramedia Volunteer.

[Chugglethwaite]

Hi there,

In SQL Server there is a system variable @@ROWCOUNT that returns the number of
rows affected by the last operation. You can SELECT this value at the end of
your update to return how many records were affected.

The SET NOCOUNT ON just stops the normal system message of "n rows were
affected" from being returned as text (which is what happens when you run the
query in Query analyser) - allowing the query just to return the value of
@@ROWCOUNT

Cheers

Andy

<cfquery name="updData" datasource="#request.ds#">
SET NOCOUNT ON
UPDATE tblTable
SET fieldname = fieldname + 1
WHERE otherfield = 0

SELECT @@ROWCOUNT AS numRows
</cfquery>
<cfoutput>#updData.numRows# were updated</cfoutput>

[chrisdonkor]

Hi folks, I need hel. I am trying to populate a database table with the query
below:
<CFQUERY name="MOdifyForex" datasource="#dbase#" dbtype="ODBC">
UPDATE tblCADForex
SET
tblCADDate = '#form.tblCADDate#',
Currency = '#form.Currency#',
BuyingRate = '#form.BuyingRate#',
SellingRate = '#form.SellingRate#',
CurrencyName = '#form.CurrencyName#',
CurrencyCountry = '#form.CurrencyCountry#',
Flag = '#form.Flag#'
WHERE tblForexID = #form.tblForexID#
</CFQUERY>

However I keep getting "Syntax error in UPDATE statement." My confusion is
that I have used this same query in other instances and it worked perfectly.
Can somebody help me out? Thanks

[mxstu]

Currency is a reserved word in some databases, but that is not necessarily the
problem here...

What database are you using? Can you post the actual SQL query from error
message. It should show the form field values that were sent to the database.