[EMAIL PROTECTED] wrote:
The ID is showing correctly in form page when I send formSounds like you could do with a good book on SQL. Someone may have suggestions...
Could somebody give an example of sql query I should use?
CFUPDATE is
UPDATE tablename SET txtField1 = '#form.field1#', numbField2 = #form.field2# WHERE anIDField = #form.IDField#
The names of the fields you pass from the form do not need to be the same as the fields in the database. Numeric values do not need to be surrounded by single quotes. Text values do. Dates, which I haven't included above, need to be in a format appropriate to your database. If you're using MS Access, then you should take a look at CreateODBCDate and similar functions.
You are also going to need to look at protecting your database from idiots. So take a look at cfqueryparam and how to use it.
Regards
Stephen
-- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
CFDeveloper Sponsors and contributors:-
*Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by
activepdf.com*
*Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com*
*Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com*To unsubscribe, e-mail: [EMAIL PROTECTED]
