How do I write the code for a button that will call a function/procedure in ASP and delete all records in an array? Should I use a function or procedure? Anyone who would like to finish this code? Code:
View RepliesI would like to know if anyone knows how to execute a stored procedure from ASP.NET 2.0. I'm using the NorthWind database and I'm trying to execute the "CustOrderHist" stored procedure. The error I get is "Incorrect syntax near 'CustOrderHist'. "
Public Function GetCustomerOrderHistory(ByVal customerid As String) As
SqlDataReader
Dim conn As New SqlConnection(conString)
Dim cmd As New SqlCommand("CustOrderHist", conn)
cmd.Parameters.AddWithValue("@CustomerID", customerid)
conn.Open()
Dim dtr As SqlDataReader =
cmd.ExecuteReader(CommandBehavior.CloseConnection)
Return dtr
End Function
How do I call a Stored Procedure with ASP?
View Replies View RelatedIs this the correct way to read a variable from a stored procedure
cmd.CommandType = adCmdStoredProc
cmd.CommandText = "sp_Supplier"
Hi i'd like to know what this line in a asp page does ?
cmd.Parameters.Append cmd.CreateParameter("Supplier",adVarChar,adParamInput,10,sChangeSupplier)
I have a Stored Procedure (SP) being called by my ASP page, but nothing is being executed. The SQL Profiler shows a RPC execute, but the actual SP is not executing as nothing is being inserted.
If I run an EXEC in Query Analyzer, with the same data being passed, it works fine and returns my OUTPUT. The SQL Profiler shows all the hits to the database then too. Code:
I'm trying to call a stored procedure(package) from asp/vb using following
code but I got the error message. What's the correct syntax for oracle stored procedured? Code:
I'm trying to call a stored procedure(package) from ASP/VB using following code. But I got the error message. Code:
View Replies View RelatedMy system is on a NT4 (w/SP6a) running IIS 4. I am developing a page that query one record from my Oracle DB 8.1.6 on a separate machine. I am using the MS ODBC for Oracle drive. In my ASP page I have (Connection object has been crreated.) then..
View Replies View RelatedI am receiving the following error from the simple script below. This works
fine from a .NET form but when I access the dll from a Classic ASP page it
fails.
Microsoft VBScript runtime error '800a0005'
Invalid procedure call or argument: 'GetGroups'
Code:
I am working on some minor modifications, face uplift and fixing some bugs/problems. This site is done in VBScript and currently is down.
When uploading a file, the following error happens on both my local machine and the development server. Code:
I get this error melding >>>Invalid procedure call or argument: 'InStr' and this is the code where this error refers to:
If (InStr(r, UCase(strRetVal), "<TABLE>") > 0) AND _(InStr(r, UCase(strRetVal), "<TABLE>") < _
InStr(r, UCase(strRetVal), "</TD>")) then ThisCellText = mid(strRetVal, StartCellText, _
InStr(r, UCase(strRetVal),"<TABLE>")- StartCellText )
Else
ThisCellText = mid(strRetVal, StartCellText, _
InStr(r, UCase(strRetVal), "</TD>")- StartCellText )
End If
in this area i am doing something, can anyone plz direct me and tell whats wrong?
I am just wodering in asp program, if there is anybody writing store procedure for inserting data into database since there are so many parameters need to be passed into store procedure(assume there are many columns in the table).
I need to insert data into two separate tables, the relation between these two tables is 1 row of data in table1 could have multiple rows in table2 related to table1, but if the data insertion into any one of the tables is failed, the transaction will roll back and no data will be remained in any of the tables.
If this needs to be handled in asp program using transact sql, how do I implement it. If I need to it using store procedure, how do I pass the error or success signal to asp program from database.
I really don't know what's happening now with my IIS, it's really annoying me, before, when I'm accesing my asp page, I got the "ActiveX component can't create object" error and that's pointing to the line of "Set objConn = Server.CreateObject("ADODB.Connection")".
And I think the registration of my components are fine. I already reinstall my MDAC 2.8 but still no luck, then I used the IIS lockdown tool and now I can run my asp pages. But there's another problem, when I used to process my first page to the second page...
It really takes a long time to process and nothing happens, and when i refreshed the page or close it....I got now this error msg "The remote procedure call failed and did not execute".
I have been modifying a forum I found on the web for a web site I am developing. Everythiing has been going great (www.tastytuscany.com/forum) until I yesterday when I hit a brick wall. There seesm to be an issue with the email functionality. The author wrote a "send_email" function that I just can't figure out why I keep getting this error:
Microsoft VBScript runtime error '800a0005'
Invalid procedure call or argument
/forum/admin/functions/functions_send_mail.asp, line 158
In the script for the email function, here is an excerpt of the code (he uses a select statement for various email types...) and a call to the function from a page. Might I just modify that include file with my own CDONT script? I use cdonts on other pages in the site just fine? BUT, I would really like to get this to work.. Code:
I'm looping through the source code of an HTML page, looking for links, grabbing the source of those links and saving each one in turn to an HTML page on disk.
This is working fine about 70% of the time, but sometimes it falls over when I try to write the source code as a text file to disk: Code:
1 I want to call an asp function through onclick method of button.
2 I want to call an asp function through javaScript
I have to code a sub procedure to do the further processing. I dont know how to call a VBScript sub procedure on the click event of a button. I tried a lot of thing but it is not working. Can any help me out or give a me tip on how to go to subprocedure on button click on an ASP page.
View Replies View RelatedI have a form which checks email addresses. On submitting the form i have some JavaScript checking the format of the email address, once this has been completed successfully I would like my asp function to run. On successful completion of that I would like my form to be submitted to another page. Is this possible?
View Replies View RelatedBy VBScript ASP
How can I call a function by click one button?
I'm trying to call asp function just simply by clicking a button But could i do this method? or how could i pass the function and values.It should be something like this:
<script LANGUAGE='VBSCRIPT'>
<!--
function btnClick_onclick
Dim strID
Dim strName
strID = document.form.txtID.value
strName = document.form.txtName.value
<%saveData(strID, strName)%>
End Function
-->
</script>
This can be in vb, vba, Delphi and a number of other development enironments - I just need to know if it can be done in ASP; if it can perhaps.
View Replies View RelatedI used this method to get the datas from array. After that, i call the function ora_login) by passing parameter but it doesn't work. It comes out 'Type mismatch' . it's there any method to do it?
for i=0 to ubound(cnn_ikh)
if i=0 then
ora = "'" &cnn_ikh(i)& "',"
elseif i = ubound(cnn_ikh) then
ora = ora & "'" & cnn_ikh(i) & "' "
else
ora = ora &"'" & cnn_ikh(i) & "',"
end if
next
parameter = ora
call ora_login(parameter)
how do I call a funciton in asp when the user clicks a button? I mean, i donīt think this will work:
<%
Sub MyFunc()
...
End Sub
%>
<input type="button" onClick="<% call MyFunc %>">
Is there a way to call an ASP function when I click on a button, without submitting the form ?
View Replies View RelatedI would like to call a C function (Unix server) from a dll (VB) based on a Windows server (ASP - II5). Is it possible? If yes, can you show me how to do it?
View Replies View RelatedI have a class. I create an instance of this class in Page_Load event. Somewhere in the page I'd like to execute an a function (public) member of this class. This function return a string. How can I call this function ?
View Replies View Relatedtrying to do an asp page for downloading contents. i want to update into database,while user click for download.
i coded like this
<a herf="filepath" >download</a>
i want to cal a update function while cilick on dat link. Now i coded the updation in dat page itself.so whenver the page visted,the database upadting,even the user click didn't click on dat link.
I am writing a web page using ASP. I have an html form when submitted the data is validated using a javascript function. BAsed on the results from the data validater is it possilbe to call a function within that same page instead of calling another URL using the Form Action statement? Or can the form action point to another .asp program, perform the logic within that program but not actually load the page
I need to load some data into our oracle database after the data is validated and am not familiar with using javascript to do this. I already have code within my program that does the database call which I would like to use.
I just want to call two exe files from asp code.
View Replies View Relatedthis them can seem absurd but I need to put this PHP code Code:
<?php include_once("ssi.php"); ?>
<? print cpg_random(); ?>
in a part of my ASP page, this is the work of that code w.sudcalifornianos.com/jala.php
(puts photos in random of coppermine gallery) it is possible?
instead of linking to say a page from some text, how can i call a function on click of the text instead?
View Replies View RelatedI am working on an asp page, but I want to validate a form from a client side, with Javascript. The problem is, I am not very sure where to call the function, either in the form tag or in the button submission. The worse is, I have no idea how to validate that function in my asp tag. Hope that someone can help. here's my code:
View Replies View Relatedi have use html below to call a function...but it seems not work. any idea about this?
<input type=button value=Submit id=Submit name="btnSubmit" onclick ="check_duplicate1()">
function check_duplicate()
dim cmd
cmd = " SELECT SERIAL_NO,ASSET_NO,BARCODE_ID FROM INST_TAB " &_
" WHERE SERIAL_NO = '" &SERIAL_NO& "' " &_
" AND BARCODE_ID = '" &BARCODE_ID& "' " &_
" AND ASSET_NO = '" &ASSET_NO& "' "
set rs = cn.execute(cmd)
if not rs.eof then
response.Write "Record Already Exist!!!"
else
response.Write "New Record Had Been Added"
end if
end function