Calling Pivot Table
I have various reports in Pivot table form using OLAP Cube. I want thes reports to be portable so i want them to call through asp so that it i available within the intranet. How do i do it?
View Replies
ADVERTISEMENT
Pivot Table Not Showing
I see a similar unanswered post here, I face the same issue.Does Win XP have some bug with Microsoft Office Web Components 11.0 ?I am unable to see a pivot table which I added, in my web page.Strangely enough, this control is showing perfectly in Win 2K with the sameweb page.
View Replies View RelatedHow To Transfer Records From One Table Of A Database To Another Table In Another Data
I have aproblem to transfer a data from table x to table y based on id. Its mean when 2 table have same id all data table x must move to table y. I don't know which command need to use is it insert into or update?
<%
Dim conn
Dim rs
Dim MYSQL,MYSQL2
Set conn = Server.CreateObject("ADODB.Connection")
Set rs = Server.CreateObject("ADODB.Recordset")
Set cmd = Server.CreateObject("ADODB.Recordset")
conn.ConnectionString = "DSN=prmm;UID=administrator;pwd=sa"
conn.Open
startdate=request("tarikh1")
enddate=request("tarikh2")
MYSQL = "SELECT * FROM table_x where paymentdate between '" & tarikh1 & "' and '" & tarikh2 & "'"
rs.open MYSQL,conn ....
How To Open A Recordset For A Table Has Space In The Table NAME?
I am trying to display the content of a Table called
'Order Detail' directly from the database (e.g., Northwind.mdb). I have the following commands:
Set tableSet = Server.CreateObject("ADODB.Recordset")
tableSet.Open table_name, DB_name, adOpenForwardOnly, _
adLockOptimistic, adCmdTable
where, table_name = ''Order Detail" Or
table_name = 'Order Detail' Or different variations.
I always get error on the second command with the following message:
Syntax error in query. Incomplete query clause
which I believe because of space in the Table Name. How can I resolve this issue? (working with file or table name with space)?
Table Inside A Table Update To DB
I have a table with many txt boxes which i have inside a form with a submit button to an update page which adds all the details to a db. The problem is i have a another table inside the first e.g. table 2. i want to be able to update table2 by clicking a second submit button that would update it. Is it possible to have a form within a form or how can i do it??
Also i need to update the entire table in one go. For exampple if i have 3 records in table2 i want to be able to update them all by clicking the one update button. Code:
Copying From Table 1 Inserting In Table 2
I have the following code but this is inserting manually. I want to make a query from table 1 and automatically enter the records into table 2. What needs to be modified? Code:
View Replies View RelatedBookmarking A Position In A Table <table>
Have an app which dynamically creates table rows depending on records, these can be several hundred (don't ask). Hence a very long page at time. Each row includes a hyper link to a new page, and a link back to the original page.
Is there any method (maybe via js) where on leaving the second page l can redirect the browser to the table row the end user clicked on? Hence the bookmarking. Can do this via Visual Basic on the desktop app, but can't work it out on the web app.
How To Get Data From A Table Into A Table Form?
I have a table produced with names across the top and services down the left hand side with boxes for numbers for people who recieve services then the info is written into a table in an access db. That works fine and here is that code:
View Replies View RelatedBest Method Of Updating Table From 2nd Table
I have two tables. Table A has 20,000 records, Table B has 2,000 records. Table A is what needs to be updated from the data in Table B. Only some fields will be updated and of course, only some records - both tables have the same field as a ClientID so matching up records should be easy.
Anyways, been a while since I have used ASP to work on things like this but would like to work through this one. I understand the process I believe, it is just how to make it go on to the next record once it has finished updating the first.
Basically, I was thinking of having it set up to reaad the top record from Table B, update applicable data in Table A. Delete that record in Table B. Move on to the next.
Record Set For Id From Table 1 To Table 2
Hello I have a page for registering users.
I am reciveing this error:
The following errors occured:
- An error occured. -2147217904 : No value given for one or more required parameters.
there are students and teachers. therefore I have 3 tables one for logins and one for staff and on for students.
I have a form designed to capeture the need information.
in the code I am runing an if and elseif statmetn to determin the tables. I then insert the userid and password into the login table.
then i enter the remaining information into ither the staff or student table. what i am trying to do is select the perimary number that is generated as the userid and passeword are enterd. and add this to the second table. Code:
Calling Vb Exe
I have got a vb exe. I want to call that vb exe from an asp page. I have saved it in the server but I dont know how to execute that from the asp page.
View Replies View RelatedCalling A Dll
I am running a project in which i use a web application writen in ASP to create some quizes, then i would like to call a compilor (dll) to compile the data i created and change it to .mms file in order to be able to send it to mobile device.
Can you please guide me on how to call the dll file from my ASP application?
Calling DLL
I have created an Active Server Component (ASC) as a bridge between ASP and my existing C++ DLLs that we use in our PC-based program. Our intent is to re-use as much code as possible.
when I call the ASC from ASP, and then call the DLL, the security profile that is specified in IIS is no longer associated with the process, and therefore, any "network-related" calls fail due to insufficient privileges.
I don't know if there is "another" way to call the DLL from the ASC or not, or any way tospecifically load a DLL with a certain security profile.
Calling Exe In Asp
i am calling an exe from asp program. Its not working fine. When i execute the exe through the dos program directly i get the desired result. My exe will convert files in the folder to encrypted files.
But when i call it thru asp program its not working fine. I have tried the
following method.
a) Calling the exe through shell program.
b) Calling the exe through ASPEXEC.
c) Calling the exe through the Batch Files.
I would like to know your suggestions.
Calling Sub
Here's a problem I can't solve.
Let n sub procedures A1, ... An
sub A1()
end sub
....
sub An()
end sub
....
I want to call indirectly one of them with a variable name like
this :
Ex :
myProc="A5"
Call myProc()
....
This doesn't work. Is there a way to solve this problem ?
Calling A Sub
i've got two pages. they have the same name for two sub procedures that do pretty much the same thing and have the same number and types of arguments. i either run one page, the other page or both. when i run page1 it somehow is accessing page2 even if it isn't called with an include statement.
page 1 is using the sub with the same name from another page even if it isn't included. so what's going on? is that normal? should i just make one page instead of 2? didn't think that sub's could jump accross pages that weren't included, but i could be wrong.
Calling Functions...
Where's the best place for me to include all my functions that I want to call throughout different pages? Should I just put them all in one ASP file and include that page on every page? Or use global.asa somehow (how??)?
Anyways, I was just wondering because I didn't want to slow things down if I could help it (I didn't know if having another big file attached to every page when I'm just using a small portion of it was very effective or not)
TypeMismatch Calling Sub
in my serverside vbscript I have:
call MySub();
......
......
then in the <Head>section I have:
sub MySub()
msgbox("Holding not found")
end sub
when I run it I get a typemismatch against the serverside call.
Anybody any ideas?
Calling SQL Script From ASP
I want to create tables in my database programatically. I know i can do it using adodb connection object. I have too many tables, views and stored procedures. If I have to write a code, I will have to write 1000 lines of code. I dont think, thats the best way to do it.
I already have a sql script for these tables, views and stored procedures. I want to know if i can execute that sql script directly from ASP.
I will explain the background, to give a better understanding of my situation. We have a website, which uses the existing database to generate reports. If we want to host that website (as a service) to third parties, we create a new database for every customer, create all the necessary tables, views and stored procedures in the new database. I want to make all the table creation programmatic. Is it possible?
Calling JScript
I'm working on a project and the designer guy uses templates for everything. THis is fine except I have to call a JScript function when the page loads and I have no access to the body tag. Is there a way to call the function as the page loads from a VBScript command?
View Replies View RelatedCalling Function From Asp
I have the following problem. I want to call a JavaScript Function from ASP
I am reading back values from a db and based on those values I want to check a checkbox.
If the value in the db field in yes then I want to check the checkbox but if it's no I want to leave the
checkbox unchecked.
My alert box is displaying but Im getting an error at the line
document.getElementById("chkStatus").checked = "true";
Calling External Sub
Im wanting to call a sub funvtion on another page from vbs that is:
<SCRIPT LANGUAGE=vbscript RUNAT=Server>
sql="exec SomeStoredProc"
call DoConnection(sql)
Response.write(recordset.getstring)
call DBClose()
</SCRIPT>
the DoConnection sub is in another page called MyDBConnection in a folder call Common.
I know that I can use serverside includes and embed my con in the page using <%%> but I want the use runat server How can I make call to a function in an external page?
Calling A Serverside
I have a database and I use asp to load it into a html table.
The first cell of each row contains a button.
What I want is that when a user clicks the button it calls a serverside sub that inserts additional rows from an other table of my database. Problem is that I don't now how to call a sub from the onclick event of the button. And I don't know if it's possible to insert rows in a html table. Does anybody know how I should do this?
Calling PHP From ASP/vbScript
wrt: Server IIS5 and IIS6
There is an application composed of PHP scripts on my server - currenly
works fine.
The site is written is ASP/vbScript. Is there any method I can use to
call the PHP functionality from within my ASP pages?
e.g include or server.execute
Screen scraping works (for some values of 'work') but seems overkill.
Calling Function
I have an Empty Function on one of my pages, so when the user clicks(submits) on the empty button in the form, the shopping cart empties. This is on basket.asp.
Code:
If (CStr(Request.Form("Submit")) = "Empty") Then
emptybasket
end if
Above is the code that empties the basket on basket.asp. Below is the Submit button code.
Calling Function
We have an asp page on a webserver supporting asp pages.
How can we run/call a function on this page using an onclick or other event
from a control. For example, when an image is clicked or a combobox is
changed. We know how to run a javascript, but would be nice to run an asp
function.
Calling Subroutine
i have defined a procedure and want it to call on the onload event of body.
<%
sub a()
----
end sub
%>
how can i achieve this. is this possible or not.
Calling Applet
I want to be able to call an applet (or possibly a servlet) from an ASP page, passing a few simple parameters.
View Replies View RelatedCalling ASP Pages
I have an application using asp and javascript. The javascript collects data and then needs to pass it to asp to store in the database. The way the original application was developed, all the data gets captured into a javascript array of records (similar to a recordset) and then each record in the array needs to go to the database. Currently I loop through the js array and open an asp window that writes to the DB then closes. This works but I get a flicker affect as this happens for each record. I'm looking for a better way to handle this - either to be able to send my entire js array of objects to ASP (don't know how to do this) or a way to invoke the asp code without opening then closing a new window everytime.YI - I recently posted a thread called "asp & javascript" that had some code snippets of what I'm currently doing.
View Replies View RelatedCalling Last ID Field?
On the last line here i'm trying to some how get it to call the last ID keyfield entry...
ImageID = Request("ID")
If (Len(ImageID) = 0) then ImageID = "1"
If Not IsNumeric(ImageID) Then ImageID = "1"
If ImageID = "0" then ImageID = "1"
If ImageID>3 then ImageID = max(Len(ImageID))
This is basically for some max min links for a online comic here's what it links to
<a href="default.asp?id=<%=ImageID-1%>">< Backwards</a> -
<a href="default.asp?id=<%=ImageID+1%>">Forward ></a> -
All works fine apart from that.
Calling Another Page
How can I call one ASP page from another
Page1.asp returns me some strings in the form of response.write
Page2.asp will call page1.asp and use that long string returned from
page1.asp....
ASP Calling ISAPI DLL
I have ASP pages that calls some ISAPI dll that created using Delphi for
generating reports. The report page opens fine for 1st time when invoked but
next time i get error like "Name not unique in this context."
My quesry string pass to dll like:
.../ReportsDLL/NameOfDLL.dll?PatID=100578&ThpID=12&State=FL
I think after the DLL is loaded it is not freeing the memory and not
unloading the dll from memory. SO How can i free memory used by the DLL or
unload the DLL from within the ASP page that load the url to
window.location?
How can I free the objects / DLL that I loaded from the ASP page using the
above querystring?
Note: I think the delphi code that is written for DLL is working fine as It
works fine for 1st time.
Calling VB Exe In Page
I have one VB exe file. Can it be called and opened in ASP page like as html form is shown. I want to execute the exe file from any machine. Should that machine have vb and sql.
View Replies View Related