|
Ok I have got my page to display the data I need using a store procedure etc. What I need to know is, how do I create an input text form box (IE: Enter ID here with a submit button and pass that variable to the (ident = 1) below to make it (ident = textboxvariable). Any help would be appreciated thanks! =)
<%Dim ident
'select your product_id
ident = 1
Dim connection
Dim rs
'create the connection
connection = Server.CreateObject("adodb.connection")
'create the connection (here we used a DSN - use any standard connection
connection.open("Driver={SQL Server};Server=X;Database=trd;Uid=X;Pwd=X;")
'create the recordset
rs = Server.CreateObject("adodb.recordset")
'open the recordset, passing in the variable
'note that the variable product_id does not have to be name the same as in the stored procedure, it just needs to be the same data type.
rs.Open("Exec GETID " & ident, connection)
'display the recordset
Do Until rs.EOF
For Each ident In rs.Fields
Response.Write(ident.value & "<br />")
Next
Response.Write("<br />")
rs.MoveNext()
Loop
rs.close()
connection.close()%>
Jesse Myer
jessemyer06@aol.com
|
|
|
|
|
Please don't cross post.
---
b { font-weight: normal; }
|
|
|
|
|
Still need help with this problem =)
|
|
|
|
|
Hello
Please I need one banner rotator for codes in html and that I can put in my website in html or javascript code. I do not want use others scipts to upload to my server.
Please can you help me?
Thanks you
|
|
|
|
|
See my reply just a few threads below.
[^]
Edit my thread by replacing those SWF filenames with the filename of your image files. Note, if you want it cross-platform, then google for alternative scripts.
modified 1-Aug-19 21:02pm.
|
|
|
|
|
Hello
Thanks you so much for your answer.
I have tried your codes but I have not result.
My codes are of the following types
Please can you help me with tags of this type
Thanks you again
Roberto
|
|
|
|
|
Sorry for delay comming back to you, have you looked at any of the sample programs/scripts at www.asp.net I seem to recall an ad-rotator there (or was it at microsoft's atlas web site/web blog (can't remember - sorry)).
modified 1-Aug-19 21:02pm.
|
|
|
|
|
Hi! I am SAMIR. iwrote a html page using qooxdoo as ....
<title>Untitled Page
window.application.main = function()
{
var d = this.getClientWindow().getClientDocument();
var insCmd = new QxCommand("Ctrl+Insert");
insCmd.addEventListener("execute", function(e){alert("Ctrl+Insert");});
var delCmd = new QxCommand("Ctrl+Del");
delCmd.addEventListener("execute", function(e){alert("Ctrl+Del");});
var escCmd = new QxCommand("Esc");
escCmd.addEventListener("execute", function(e){alert("Esc");});
var contextMenu;
function createMenu()
{
contextMenu = new QxMenu();
var insMenuBtn = new QxMenuButton("Add New Document",
"scripts/themes/icons/crystalsvg/16/apply.png", insCmd);
var delMenuBtn = new QxMenuButton("Detach This Document",
"scripts/themes/icons/crystalsvg/16/edit-delete.png", delCmd);
var lnMenuSptr = new QxMenuSeparator();
var escMenuBtn = new QxMenuButton("Exit", "scripts/themes/icons/crystalsvg/16/exit.png",
escCmd);
contextMenu.add(insMenuBtn,delMenuBtn,lnMenuSptr,escMenuBtn);
d.add(contextMenu);
};
function showMenu()
{
createMenus();
contextMenu.show()
};
};
i want when ever i right clicked on any row of the table, then context menu should be displayed. for this i used code: oncontextmenu=’showMenu(); return false;’ on every row of table. but context menu doesn't display. please help me.
|
|
|
|
|
Perhaps if you call "createMenu" instead of "createMenus". 
---
b { font-weight: normal; }
|
|
|
|
|
i like to disable close button ,is it possible through script.
i m using window.open() method but tilebar=1 as i want titlebar but not want X (close) button on right side of title bar.
plzzz tell any solution
jagmit
|
|
|
|
|
to remove all the header and footer of the print out of my webpage using java script solutions
is there any idea please help me
|
|
|
|
|
There is an easy way of doing this with CSS, if its any help.
If your header and footers are enclosed in a div tag, eg <div id="header">
You can specify a stylesheet for print output which can hide required divs.
In the head of the page put
<style type="text/css" media="print" src="print.css">
In your print.css file (or whatever you want to call it)
#Header, #Footer{
display:none;
}
The header and footer will still be displayed on screen, but will not be printed. This is also useful for hiding sidebars, navigation etc.
Words fade as the meanings change, but somehow, it don't bother me.display:nione
|
|
|
|
|
Ok first, I'll outline my project. It is a web application made to search and display records of archived technical documents. What I have right now is a page that uses datagrids (via drag and drop from Visual Studio 2005) to display columns of data from my SQL Test server.
What I need now is a way to create a simple form text box and create and pass a variable to the SELECT statement within the datagrids. All my attempts at this thus far, using both ASP and C# and MSDN knowledgebase, have ended in frustration.
Here is the code of the datagrid:
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
DataSourceID="SqlDataSource1" EmptyDataText="There are no data records to display.">
<Columns>
<asp:BoundField DataField="OVERVIEW" HeaderText=" " SortExpression="OVERVIEW" />
</Columns>
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="
<%ConnectionStrings:trdConnectionString2 %>"
ProviderName="<%$ ConnectionStrings:trdConnectionString2.ProviderName %>"
SelectCommand="SELECT [OVERVIEW] FROM [SUDS_TRD] WHERE [IDENT]='1'">
</asp:SqlDataSource>
What I need to do is where it says [IDENT]='1', is have that "1" be a parameter passed from an HTML form, perhaps looking like this WHERE [IDENT]='"% strIDENT %"', yet I do not know how to pass a parameter from an HTML form into that SELECT statement. Any help would be great as this is a problem holding up my project.
To reiterate, I need to:
A. create an html form text box
B. pass that textbox as a variable
C. place that variable into the SELECT statement for the ASP datagrid.
Any help would be great, example code, whatever it takes; the simpler the better =) Please just don't send me to MSDN's Datagrid Knowledge Base page as 1/2 the stuff there doesn't even work =[.
Thanks for any help in advance!
|
|
|
|
|
Soot,
A couple questions, do you get static(unchanging) data populated in your datagrid as it is? Do you want the end user to enter a variable into the text box to repopulate the datagrid?
As I understand what you've given so far you're going to need a text box, which you can drag and drop where you want it; a button with an OnClick event that will take the text and initiate the SQL statement, you can d&d the button and set the name of the event on the Design screen but the functionality has to be set on the code behind(aspx) page.
I'm fairly new to this myself but I've been working with datagrids for a while and maybe I can help.
An American football fan - Go Seahawks!
Lil Turtle
|
|
|
|
|
|
Hi all,
What is the best way to build reports using Reporting Services based on data from SharePoint? (Users enter data to SharePoint Form Library using InfoPath and managers need to build reports based on that data)
Thanks,
Stas
|
|
|
|
|
Hello,
I generate with JS some HTML-Elements (Div, Hidden and Select) inside a Span-Tag. The Span is positioned absolut with JS after pressing a button. Now I see the Select-Element correct filled, but a static HTML-select-element of this page is displayed OVER the dynamic generated select. See Screenshot:
www.stephan-pilz.de/1.jpg
After I resize the window (manual with mouse !!!) in vertical direction, my dynamic select is displayed OVER the static (this is what I want). See screenshot:
www.stephan-pilz.de/2.jpg
Did anybody know, why the static select is displayed OVER the dyn. select?
Or has anybody some ideas, how I can resize this window and back, to do the manual proc. with JS. For this case, I have try many things with window.resizeTo, .resizeBy, document.body.clientWidth and so on. Nothing of this works.
PLEASE NOTE: The code must only work in IE and the window contains an frameset!!!
Many thanks. ![Rose | [Rose]](https://codeproject.global.ssl.fastly.net/script/Forums/Images/rose.gif) I'm hopelessly. 
Stephan
\\\| \\ - -
( @ @ )
+---------------oOOo-(_)-oOOo-----------------+
| Stephan Pilz stephan.pilz@stephan-pilz.de |
| <a href=www.stephan-pilz.de>www.stephan-pilz.de</a> |
| ICQ#: 127823481 |
+-----------------------Oooo------------------+
oooO ( )
( ) ) /
\ ( (_/
\_)
|
|
|
|
|
You could try by specifying the z-index of the elements, but I'm not sure how well the select elements would respond to that.
IE 6 is using a standard Windows control for the select list, so it doesn't play very well with other elements in the browser. I would suggest that you change the layout so that you won't have select elemenents on top of each other.
---
b { font-weight: normal; }
|
|
|
|
|
Hm. Not bad idea with the z-Index. Did you know, how I can change that?
It's is unfortunately not possible to change the static elements in the page.
Stephan
\\\| \\ - -
( @ @ )
+---------------oOOo-(_)-oOOo-----------------+
| Stephan Pilz stephan.pilz@stephan-pilz.de |
| <a href=www.stephan-pilz.de>www.stephan-pilz.de</a> |
| ICQ#: 127823481 |
+-----------------------Oooo------------------+
oooO ( )
( ) ) /
\ ( (_/
\_)
|
|
|
|
|
Now I tried to set the z-order via .style.zIndex to 999 of my dyn. select and to 0 of the static select. That does not solve the problem.
Any other ideas ?
Thanks
Stephan
\\\| \\ - -
( @ @ )
+---------------oOOo-(_)-oOOo-----------------+
| Stephan Pilz stephan.pilz@stephan-pilz.de |
| <a href=www.stephan-pilz.de>www.stephan-pilz.de</a> |
| ICQ#: 127823481 |
+-----------------------Oooo------------------+
oooO ( )
( ) ) /
\ ( (_/
\_)
|
|
|
|
|
The select is displayed over because the listboxes generated by the browser do not take z-order styles - i think it's something to do with them actually being windows controls (vague memory...).
Anyway, there is a workaround - if you want to put something over a listbox (we had this problem with dynamically created dropdown menus), you can create an iframe the same size as whatever you want to go over your listbox and one z-order underneath it (i've heard the term shim for this). The iframe hides the select box. So if you could look at your page in height it'd be like this:
div to display
iframe
select to hide
PAGE
|
|
|
|
|
Hello Paddy,
thanks for your answer. Your hint (undoc. feature) solves my problem.
BR
Stephan
\\\| \\ - -
( @ @ )
+---------------oOOo-(_)-oOOo-----------------+
| Stephan Pilz stephan.pilz@stephan-pilz.de |
| <a href=www.stephan-pilz.de>www.stephan-pilz.de</a> |
| ICQ#: 127823481 |
+-----------------------Oooo------------------+
oooO ( )
( ) ) /
\ ( (_/
\_)
|
|
|
|
|
i hav three advertisements as flash movies(ad1.swf,ad2.swf,ad3.swf). i hav a combination of object and embed elements. i want these ads to reapted one after the other. each ads should stay for 1 minute. how can i rotate these ads in javascript?
Thanks.
|
|
|
|
|
var RunningIE4<br />
RunningIE4 = (msieversion() >=4);<br />
function msieversion() {<br />
var ua = window.navigator.userAgent<br />
var msie = ua.indexOf ( "MSIE " )<br />
if ( msie > 0 )
return parseInt ( ua.substring ( msie+5, ua.indexOf ( ".", msie ) ) )<br />
else<br />
return 0
}<br />
<br />
var curBanner<br />
curBanner = 0<br />
Bfiles = new Array()
Btargets = new Array()
Balt = new Array()
Bfiles[0] = "ad1.swf"<br />
Btargets[0] = "http://www.the web address"<br />
Balt[0] = " description - can be blank"<br />
Bfiles[1] = "ad2.swf"<br />
Btargets[1] = "http://www.the web address"<br />
Balt[1] = " description - can be blank "<br />
Bfiles[2] = "ad3.swf"<br />
Btargets[2] = "http://www.the web address"<br />
Balt[2] = " description - can be blank"<br />
<br />
function startBanner() {<br />
window.setInterval("changeBanner();",60000);<br />
}<br />
function changeBanner() {<br />
if (RunningIE4 == true) {<br />
if (curBanner == (Bfiles.length -1)) {<br />
curBanner = 0;<br />
} else {<br />
curBanner++}<br />
Banner.src = Bfiles[curBanner]<br />
BannerTag.href = Btargets[curBanner]<br />
Banner.alt = Balt[curBanner]<br />
}<br />
} <br />
and later in the web page
<br />
<SCRIPT LANGUAGE="JavaScript"><br />
if (RunningIE4 == true) {<br />
document.write("<A NAME='BannerTag' HREF='" +Btargets[curBanner]+ "' TARGET='_new'><IMG NAME='Banner' BORDER=0 SRC='" +Bfiles[curBanner]+"' ALT='"+Balt[curBanner]+"' ></A>")<br />
}<br />
</SCRIPT><br />
<NOSCRIPT> <A HREF="non-ie webpage.htm">for non MSIE browsers</A> </NOSCRIPT>
modified 1-Aug-19 21:02pm.
|
|
|
|
|
Thank you for your coopertion.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
