strTemp="Select * table1 where column1 =" & session("whatever")
(Vb.net)
orstrTemp="Select * table1 where column1 =" & session["whatever"] (C#) On Mon, 21 Feb 2005 19:07:13 -0000, higzog <[EMAIL PROTECTED]> wrote: > > Thanks - what does the command that passes it to the SQL select > statement look like from example below: > Select * table1 where column1 = (what do I put here to pass the > session variable into the statement) > > > > --- In [email protected], "scaevola637" > > <[EMAIL PROTECTED]> wrote: > > > > Pass it as a paramter to a SPROC or include it in the string of the > > SQL Statment. Fairly Straightforward. SPROCS are recommended as > > they are optimized > > > > > > --- In [email protected], "higzog" <[EMAIL PROTECTED]> > > wrote: > > > > > > How do I use a session variable in an SQL select statement in > > order > > > to limit the record pulled from the statement to equal the value > > of > > > the session variable? > > > .NET and SQL > > > > > > > Yahoo! Groups Sponsor > > > Get unlimited calls to > > U.S./Canada > > ________________________________ > Yahoo! Groups Links > > To visit your group on the web, go to: > http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/ > > To unsubscribe from this group, send an email to: > [EMAIL PROTECTED] > > Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
