Var from Cookie into a SQL query in ASPX
-
I just need to get my cookie value as a variable into my SQL query. That is all. PLEASE can someone help. I just do not seem to get it done. The Cookie in the rest of the code reads in fine and displays, but I cannot get it to work in the SQL statement. Using Dreamweaver. Here is the code. Just the WHERE part of the SQL query? Thanks guys and gals. ------------------- anguage="C#" %> <%@ Register TagPrefix="MM" Namespace="DreamweaverCtrls" Assembly="DreamweaverCtrls,version=1.0.0.0,publicKeyToken=836f606ede05d46a,culture=neutral" %> <%@ Register TagPrefix="Portal" TagName="ImageCanvas" Src="ImageCanvas.ascx" %> <%@ import Namespace="System.Drawing" %> void Page_Load(Object sender, EventArgs e) { HttpCookie UserCookie = Request.Cookies["AuthenticateGKDUser"]; if (null == UserCookie) { Response.Write("No cookie");} else{ String UserCookieValue = UserCookie.Value.ToString(); Response.Write(UserCookieValue); } Pen newpen = new Pen(Color.Black); Pen PartnerPen = new Pen(Color.Blue); Pen ClientPen = new Pen(Color.Red); Bitmap bitmap4 = new Bitmap(500,500); Graphics g4 = Graphics.FromImage(bitmap4); g4.Clear(Color.White); g4.DrawLine(newpen,250,250,250,0); g4.DrawLine(newpen,250,250,367,29); g4.DrawLine(newpen,250,250,457,110); g4.DrawLine(newpen,250,250,499,224); g4.DrawLine(newpen,250,250,482,344); g4.DrawLine(newpen,250,250,411,442); g4.DrawLine(newpen,250,250,302,495); g4.DrawLine(newpen,250,250,181,490); g4.DrawLine(newpen,250,250,70,424); g4.DrawLine(newpen,250,250,12,327); g4.DrawLine(newpen,250,250,3,211); g4.DrawLine(newpen,250,250,48,103); g4.DrawLine(newpen,250,250,137,27); switch(cWork) { case 10: cWorkStrX = 250; cWorkStrY = 0; break; case 9: cWorkStrX = 250; cWorkStrY = 25; break; case 8: cWorkStrX = 250; cWorkStrY = 50; break; case 7: cWorkStrX = 25</x-turndown>