information. Though since you already have all the info in the request's
FORM variables, why not just use those to build the notification email?
Cheers,
barneyb
> -----Original Message-----
> From: Christy [mailto:[EMAIL PROTECTED]
> Sent: Monday, June 07, 2004 9:55 AM
> To: CF-Talk
> Subject: how to re-query a cfquery?
>
> I have a query at the beginning of my CF page that
> 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]
