now, just trying to "fix" the code of the person doing
it before me. ahhhh, so much to learn :)
thanks to everyone who answered my question - it works
now!
christy
--- Barney Boisvert <[EMAIL PROTECTED]>
wrote: > You can just rerun the query, after the
update, so
> you get the new
> 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]
