Not an answer to your question, but in your first query if username isn't unique you might not get the desired result.
Ade -----Original Message----- From: Garry Mills [mailto:[EMAIL PROTECTED] Sent: 12 March 2003 12:04 To: '[EMAIL PROTECTED]' Subject: [ cf-dev ] Strange update problem OK, so a user logs on and I store his user name as a session variable. If he wants to change his preferences, the script goes... <cfquery datasource="#application.datasource#" name="get"> select * from users where user_username = '#session.username#' </cfquery> Boring so far. Captures the right info, into the form with values set blah blah blah Submits the form, query goes <cfquery datasource="#application.datasource#"> update users set user_forename = '#form.user_forename#', ...etc... where user_username = '#session.username#' </cfquery> Which does jack all. user_username is a replication ID (it's an MS Access datasource at the moment)) It isn't Friday already is it? I'm obviously missing something completly obvious CF 4.5 on Win2K for what it's worth Garry -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
