now is I need to return some values from a temp table and output them. I
can do this fine on my processing page:
<cfquery name="deDupeSegments" dbtype="odbc" datasource="#Client.DS#"
username="#Client.UID#" password="#Client.PWD#">
EXEC #Client.DBPrefix#.uspCrossSegmentEmailRemove
@Str = '#Keys2#'
</cfquery>
<cfoutput query="deDupeSegments">
#SegmentKey#, #SegName#, #Num#
</cfoutput>
However, I need to send this information to another page. Something
like:
<cflocation url="" addtoken="no">
How can I get the query results passed to my other page?
Thanks.
> This is a multi-part message in MIME format.
>
>
> Thanks for the reply. I did change the delimiter to | instead of a
> comma. It turns out though I needed to change my declare @Str
> Varchar(255) to @Str VarChar(255) and move to above the "AS".
>
> Now it works like a charm.
>
> > This is a multi-part message in MIME format.
> >
> >
> > My guess is that it has to do with your pipe character | as you list
> > delimiter. Have you tried:
> >
> > @Str='#Keys#' to see if that helps? Or try a different delimiter...
> >
> > Sincerely,
> >
> > Dave Phillips
> > National Marketing Director
> > Legacy for Life
> > 615-746-3851
> > [EMAIL PROTECTED]
> >
> >
> > ________________________________
> >
> > From: NashGuy [mailto:[EMAIL PROTECTED]
> > Sent: Wednesday, June 09, 2004 2:04 PM
> > To: CF-Talk
> > Subject: Passing list into SQL
> >
> >
> > Hi all,
> >
> > I have been having a heck of a time with trying to pass a list into
a
> > stored procedure and have it parsed out. The problem I am having is
> > getting CF to pass the list into the stored procedure. Can someone
> point
> >
> > me in the right direction?
> >
> > Thanks.
> >
> >
> >
>
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
