|
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; }
|
|
|
|
|
|
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
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 
|
|
|
|
|
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..
|
|
|
|
|
|
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.
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 )?
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
Thanks a lot
Lukas
|
|
|
|
|
Error msg that I get now running my ASPX page (With graphics stuff in created in Dreamweaver)
All was running fine. Had .NET installed. All working. Had to change the access permissions on my folders to allow IUSER_SERVER access so that my DB's will work. (WHICH they now do) BUT since I have changed my access permissions, my ASPX page just gives me this error msg. Any ideas? What would the access permissions have to do with this and how to fix it?
ERROR :
Server Application Unavailable
The web application you are attempting to access on this web server is currently unavailable. Please hit the "Refresh" button in your web browser to retry your request.
Administrator Note: An error message detailing the cause of this specific request failure can be found in the application event log of the web server. Please review this log entry to discover what caused this error to occur.
CODE: ASPX Page
<%@ Page Language="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" %>"
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) {
Pen newpen = new Pen(Color.Black);
Bitmap bitmap4 = new Bitmap(300,300);
Graphics g4 = Graphics.FromImage(bitmap4);
g4.Clear(Color.White);
g4.DrawLine(newpen,5,5,20,20);
g4.DrawLine(newpen,5,5,50,5);
ImageCanvas4.bitmap = bitmap4;
}
<portal:imagecanvas id="ImageCanvas4" runat="server" imagetype="Jpeg">
And still more info
CODE : ASCX PAGE
<%@ Control Language="C#" %>
<%@ import Namespace="System.Drawing" %>
<%@ import Namespace="System.Drawing.Imaging" %>
public Bitmap bitmap;
public ContentType ImageType = ContentType.Jpeg;
void Page_Load(Object sender, EventArgs e) {
if (Request.Params[ID] != null) {
Response.Clear();
Response.ContentType = "Image/" + ImageType.ToString();
bitmap.Save(Response.OutputStream,getFormat((int)ImageType));
Response.End();
}
String Url = Request.Url.ToString();
if (Url.IndexOf("?") == -1) {
DyImage.ImageUrl = Url + "?" + ID + "=Show";
}else{
DyImage.ImageUrl = Url + "&" + ID + "=Show";
}
}
ImageFormat getFormat(int i){
ImageFormat imgfmt = ImageFormat.Jpeg;
switch(i){
case 0:
imgfmt = ImageFormat.Gif;
break;
case 1:
imgfmt = ImageFormat.Jpeg;
break;
case 2:
imgfmt = ImageFormat.Png;
break;
}
return imgfmt;
}
public enum ContentType{
Gif=0,Jpeg=1,Png=2
}
<asp:image id="DyImage" runat="server">
this is me
|
|
|
|
|
Hello World!,
I want to order the data of each column in a table when clic on the header of the column.
I try with:
http://www.glendinning.org/webbuilder/sortTable/
but have problem with the data type int and string.
gangeles
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
