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]
