Var from Cookie into a SQL query in ASPX - Web Development Discussion Boards

Interesting, very interesting, indeed.
I think these Folders which have long names(some code) are like Blackholes where you dump in these troubled items so that they somehow gets flushed out.
If I find out what is happening, I will let you know.
Thanks.

Which is the best way I can put "LAST MODIFIED AT ....." in my website.

What is best way to get the 'last modified time' from my application.
I want to get the last time when I compiled the application.

Pls. Help
Pls provide ur valuable Suggestions..

"I firmly believe that
any man's finest hour,
the greatest fulfillment of all that holds dear,
is that moment,
when he has worked his heart out in a good cause
and lies exhausted in the field of battle - victorious..."

user session variable, if ur website in asp
or use one field in database, and update then display in page.

use application variable to perform this.

Editor
http://www.allthewebsites.org
WebDirectory | webhosting | WebTemplates

I am trying to have a table loaded dynamically from a database when an HTML button is pressed. My code looks as follows:

In the section:
<%
Dim objConn
Dim connStr
Dim TableName1, TableName2
Dim strQuery
Dim rsMessage

Set objConn = Server.CreateObject("ADODB.Connection")
connStr ="PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=" + Server.MapPath("combine.mdb")
objConn.Open(connStr)

TableName1 = "VCC Combine"
TableName2 = "San Jose Combine"

strQuery = "SELECT * FROM ["+TableName2+"]"

Set rsMessage = objConn.Execute(strQuery)
%>

Sub VCCCombine_Click()
strQuery = "SELECT * FROM ["+TableName1+"]"
End Sub
Sub SanJoseCombine_Click()
strQuery = "SELECT * FROM ["+TableName2+"]"
End Sub

In the BODY section:

In the TABLE section:
<% While Not rsMessage.EOF
Response.Write("")
%><%=(rsMessage.Fields.Item("Player").Value)%><%
Response.Write("")
%><%=(rsMessage.Fields.Item("School").Value)%><%
Response.Write("")
%><%=(rsMessage.Fields.Item("Position").Value)%><%
Response.Write("")
%><%=(rsMessage.Fields.Item("Height").Value)%><%
Response.Write("")
%><%=(rsMessage.Fields.Item("Weight").Value)%><%
Response.Write("")
%><%=(rsMessage.Fields.Item("Vertical Leap").Value)%><%
Response.Write("")
%><%=(rsMessage.Fields.Item("Bench Reps @ 185lbs").Value)%><%
Response.Write("")
%><%=(rsMessage.Fields.Item("Bench Reps @ 135lbs").Value)%><%
Response.Write("")
%><%=(rsMessage.Fields.Item("20-Yard Shuttle").Value)%><%
Response.Write("")
%><%=(rsMessage.Fields.Item("40-Yard Shuttle").Value)%><%
Response.Write("")
rsMessage.MoveNext
Wend
objConn.Close()
%>

If I don't add the buttons, the table gets loaded correctly. I really would like to have the Table change when the button is selected. Any ideas here would be appreciated...

You are mixing server side code with client side code.

Consider these two rules:

1. The server side code and the client side code never exist in the same place.
2. The server side code and the client side code never exist at the same time.

The code on the server side is connecting to the database, getting the data and putting the data in the code that will become the html table. Then the recordset is closed (only you forgot to do this), and the connection is closed. After that, the page is sent to the browser.

In the browser, when you click a button, all it does is to put a value in a variable that is called strQuery. It uses the variables TableName1 or TableName2, but they are empty. You had variables with the same names in the server code, but those variables are long gone, and they existed in a completely different place.

Once the strQuery variable has gotten a value, nothing happens. You don't have a database connection or a recordset, and there is no code that does anything at all with the value in the strQuery variable.

To get a look at what's going on, once the page loads in the browser, use the View Source command to look at the page code that the server code has created. You will see your two subroutines, the two buttons, and a table with text in it. That's all that you have at that point.

If you want the contents of the table to change, you have to reload the page so that the server code is executed to create a new page. You have to send something to the server so that the server code can determine what choise you have made. One way is to simply make the buttons into submit buttons, then you can use Request.Form to check which one of the buttons wass pressed.

---
b { font-weight: normal; }

i think in vbscript black have a problem.
pl. revise that coding then try it. Smile | :)

Editor
http://www.allthewebsites.org
WebDirectory | webhosting | WebTemplates

Hi,

Does anyone has the idea about how to get/buy the whois database?

I need to get domain registered information from the database. I can not use the public service cause they all have limited.

Thanks a lot in advance!

Alan Shen

MCAD for .NET Version
^~^~^~^~^~^~^~^~^~^~^
Great idea is the beginging of success!

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" %>
<mm:dataset
id="DataSet1"
runat="Server"
isstoredprocedure="false"
connectionstring="<%# System.Configuration.ConfigurationSettings.AppSettings["MM_CONNECTION_STRING_loginaccess"] %>"
databasetype="<%# System.Configuration.ConfigurationSettings.AppSettings["MM_CONNECTION_DATABASETYPE_loginaccess"] %>"
commandtext="<%# "SELECT * FROM Users <b>WHERE username = Request.Cookies["AuthenticateGKDUser"]" </b>%>"
debug="true"
="">
<mm:pagebind runat="server" postbackbind="true">

<%@ 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 = 250;
cWorkStrY = 75;
break;
case 6:
cWorkStrX = 250;
cWorkStrY = 100;
break;
case 5:
cWorkStrX = 250;
cWorkStrY = 125;
break;
case 4:
cWorkStrX = 250;
cWorkStrY = 150;
break;
case 3:
cWorkStrX = 250;
cWorkStrY = 175;
break;
case 2:
cWorkStrX = 250;
cWorkStrY = 200;
break;
case 1:
cWorkStrX = 250;
cWorkStrY = 225;
break;
case 0:
cWorkStrX = 250;
cWorkStrY = 250;
break;
}

g4.DrawLine(ClientPen,cWorkStrX,cWorkStrY,cPartnerStrX,cPartnerStrY);

ImageCanvas4.bitmap = bitmap4;
}

<portal:imagecanvas id="ImageCanvas4" runat="server" imagetype="Jpeg">

And still more info

this is me

When I use MsgBox() in my ASP code, written out as VBScript code, then my dialog window box appears with the title prefixed with "VBScript:". So if the title of the dialog window was suppose to be "Save changes", it looks like "VBScript: Save changes". Is there any way to not display the "VBScript:" label?

I'm getting this JavaScript error message in my application (which is C#, written in .NET 2002, running on .NET Framework v1.0):

"The callee (server [not server application]) is not available and disappeared; all connections are invalid. The call did not execute."

This is the situation:

The homepage has several usercontrols. The important ones are

1. A User control that provides a menu bar.
This menu bar contains 4 links - 2 are to external websites, the other 2 are links to open internal modeless popup windows.

2. A user control that provides a link to a pdf document, which is opened using acrobat in IE.

Scenario1: When I go into the homepage, and click the link, everything's fine - the pdf is displayed.

Scenario2: Click the menu control for one of the external sites. This opens in new window. Return focus to the homepage of my site and click the pdf link. Everything's fine - the pdf is displayed.

Scenario3: Click this menu control to open one of the popups. The popup is displayed correctly as a modeless dialog window. Return focus to the homepage and click the pdf link.
In this scenario, the page will not open. In the development environment the code breaks with the above message. This happens regardless of whether the popup window is still open, or has ben closed.

The user control for the pdf link looks like this:
<%@ Control Language="c#" AutoEventWireup="false" Codebehind="PdfLinkUserControl.ascx.cs" Inherits="MyCompany.Web.UI.UserControls.HomePage.PdfLinkUserControl" TargetSchema="http://schemas.microsoft.com/intellisense/ie5"%>

Click Here

The function is in a separate .js file in the solution
function popupWindow(sUrl)
{
window.open(sUrl);
}

Any help on this would be greatly appreciated, thanks for taking the time to read it all Big Grin | :-D

By the way, I've seen a lot of sites suggest that this has to do with popup blockers, but I don't have any, so I know its not that in this case.

Thanks again

Hi all,
Whether I can send email with from address as a name instead of email id?
i.e. I don't want to display my mail id in from address when the recepient get the mail, instead a name should be displayed. I am using CDONTS.
Thanks in advance.
Regards,
Anaha Smile | :)

Hi,

I need to build a huge web application and I want to try and sort out my folder hierarchy. I'm using Visual Web Developer Express with Framework 2.0. I want to group all related files in one folder. Currently I have started but not sure if it is right. There are many ways, I know, but I want to follow industry standards. Can someone please give me a basic guideline on file structures when creating an applicaion.

I have it like this so far:

root
App_Code
common (used for global variables)
components
BLL
DAL
App_Data
App_Themes
images
includes
stylesheets
javascript

I want to include alot of stuff, like email utilities, page settings, images, includes files (user controls) like headers and footer, exception, page errors, rich textbox editor, menus, etc. I like the way that DotNetNuke and Rainbow starter kits did it. I don't want to to through all my files in one directory, but have them neatly organised.

Please can you people advise!!

Regards,
ma se

hi..
i m doing a project on SPAM filter(SPAM killer).
i m very new to the concept..pls let me know wat are the various approaches(methods,Algorithms)to get through this project.
Thank you...

chippu..

In my research paper Applications of Fuzzy-Neural Networks In Building A Spam Filter[^], I dedicate Section 1 to a brief discussion of the state of the art of spam fighting.

In the assoicated presentation[^], I dedicate slides four through eleven covering the art.

"we must lose precision to make significant statements about complex systems."
-deKorvin on uncertainty

Hi Evryone !!!

I hav a quik question :

I am trying to write a code to check if my system is idle for say 5 mins , if yes then it should open IE to a specific webpage ...or if IE is already open it shud Redirect it to my specified webpage.

thanks

Maneesh

I have a webpage in which there is a
Marque effect .
when the move move over that area i
want to stop the scrolling text can
anyon tell .

Vikas Amin
Embin Technology
Bombay

Hi,
I need to make user to access its directory structure, allowing him to choose one folder through the dialog box/ tree view control.... Is there any code for this functionality using JavaScript??

Manjeet Singh

Not in a web page. Only if you make an Hypertext Application (.hta) file.

An Hypertext Application is just a regular web page, but with the .hta file type. This will cause the browser to ask the user to allow the page to run, after that you will have access to the files through the Scripting.FileSystemObject class.

---
b { font-weight: normal; }

Hello fellow developers!

In the office we got into a discussion on how you should store a zip code in a database. In Denmark zip codes are just 4-digit numbers like: 8340 or 6400.

Would you store them as strings or would you store them as integers?

Regards
Soeren

If there is an even remotely risk that the system at any time needs to store addresses outside of Denmark, I would store them as strings.

Some countries have letters in the zip codes, swedish zip codes are five digits but they are written with a space between the third and fourth digit.

---
b { font-weight: normal; }

Hi all, I have lately started doing some development on ASP.

Anyways,
I have installed interdev 6.0 at home and office. But the interface for ASP editor looks very different at home.

At home Visual Interdev does not have that 3 tabs, at the bottom i.e. design, source and quick view. While the Interdev at office has those tabs.

Any idea how to enable that feature in Visual Interdev or have I missed installing some components.

I have IIS and ASP script engine installed at home on Windows 2000.

The same problem is there with Microsoft frontpage too.

Confused | :confused:

Thanks in advance.

-Prakash

-- modified at 6:16 Monday 16th January, 2006

Well i resolved the problem, I uninstalled and reinstalled the visual interdev component of VS6.

i guess it somehow got screwed up by installing/uninstalling of VS.NET

Things are nice and good.

Is there any suggestion on a good ASP editors (except for notepad or texpad kinda stuff Smile | :)

)?

Thanks again.

-Prakash

Does anybody knows how to implement spell checking in ColdFusion OR Perl ?

Sorry, I missed your post. I hope this response is not too late.

For PERL, I've used Speller Pages[^] with success.

For ColdFusion, I've used Jazzy[^] wrapped in a Java class as described in this article[^].

"we must lose precision to make significant statements about complex systems."
-deKorvin on uncertainty

Hi! Yes I know that this is brutal off-topic, but I realy need help. I want begin to programmig an internet aplications in Flash. Web sites designeds in flash. I dont know how does it works. I have experience with C, C++ and C# as well as with PHP and later i turned into .NET - ASP.NET. If somebody has usefull suggestions, please send me an email. If not, just ignore this ask Smile | :)

Thanks a lot
Lukas