gets the registration info of a certain user...
<cfoutput>
<cfquery name="getreginfo"
datasource="#application.dns_name#" dbtype="ODBC" >
SELECT * FROM Users WHERE username = '#form.username#'
</cfquery>
</cfoutput>
later on in the page, i use this statement to update
the user's details, based on details they give upon
renewing their subscription...
<cfupdate datasource="#application.dns_name#"
tablename="Users"
formfields="MonthsSubscribed,user_ID,pointsremaining,
PointsExpireDate,subtype,accesslevel">
then i send out an email to admin telling the user
details...problem is, i want it to give the NEW user
details, as updated in the database above. it sends
out an email with the OLD user data, before update. i
guess since the query is done as soon as the page
loads.
is there a way i can re-query the user database just
before i send out the admin email?
does this make sense? ask me for more details if
necessary. :)
thanks!
christy
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
