I have an asp module connecting to a MS-access database.
I have a vb function MKDate(date, time) in a vba module of this
database.
I would like to query :
SELECT MKDATE(col1, col2) FROM TABLE1
(real query is complex, using unions, etc, but I need one column in
resultset)
But I get an error opening the recordset
"Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] Undefined function 'MKDATE' in
expression.
/selfmail/dossier.asp, line 729"
I also tried to copy the code of the function MKDate(date, time) inside
..asp module, no change.
Is it possible to call a vba function inside an asp sql statement?
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";
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.
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.
I have an ASP application that calls a COM function to create a custom report as an Excel file. This works in a synchronous fashion, as long as the report does not take too long to create. If that happens, the session times out and we run into other kinds of problems.I have, in other cases, executed a stored procedure asynchronously thru ADO. I'm wondering if ASP provides some way of executing a function (an ASP function, not ADO) asynchronously? I could then make the call to the COM function from within this async thread, and implement the same refresh logic on the client that we used in the ADO solution.
When i get a record in my form i want to check the expiry date in that record. If expiry date is today's date then i want to send an email to the admin asking him to renegotiate the tender. Comparing the date i am doing in javascript and if dates are same then i m marking a variable as true. I m puttin this variable's value in a textbox. Now i want to check in asp that if this variable is true then send email.
i have created one asp page in which in the javascript code i have written one functions. function date() { } From another asp page i want to call the date() function. How do i go abt it.
I'm new with asp and javascript. I have this javascript function (at the beginning of my asp page) to open new window:
<script language="javascript"> { Function NewWin(pstrPageName)window.open(pstrPageName,null,"width=600,height=400,toolbar=no"); End Function } </script>
Users would fill out the criteria on the page and click OK. Base on the specified criteria, I build an html page (with dynamic pagename and data). I'd like to call the function NewWin from asp code (passing the pagename) to open new window. I tried:Call NewWin(strPageName) but got an error the NewWin is undefined. URL . Can someone help me to code this?
i want to have alert for my delete process. but I have no idea how to call my function in this case. this is the text.
<a href="padamlaporan.asp?idl=<%=id_laporan%>&i=<%=request("i")%>">Padam Laporan</a> i want to call this function.
function padambutirlaporan(){ if (confirm('Adakah anda pasti untuk padam laporan ini?')){ document.location.href = "padambutirlaporan.asp?idl=<%=id_laporan%>&i=<%=request("i")%>";
Response.Write("<script>isFlash();</script>") is what I had attempted for calling my function isFlash().
I have added the following script at the top of my code, so I cannot see a problem here, is there a method in which you must go through in order to get this to work correctly, have I added the function call correctly?
<script language = "javascript"> function test1() { ------------ <%test()%> // fine and works well if there is no response.write() in test() as i know. } </script>
now the problem is that how can i call test1 within scriplets or within test().
i am looking to create a form that has a link that when clicked it passes to a javascript function and runs a js prompt to enter a figure. then when confirmed that figure entered becomes the new record in the database.
so far i am using things like this just to get it to display an alert so i know its working. Code:
I have create a function in javascript and the function will return an integer type of value and i want to call that function in Asp code and use that integer value so please tell me how can i call that function.
It's a simple validation page and was working fine until i made some changes to the next page.
A regular form that calls a javascript function, but suddenly i javascript function does not execute anymore. i tried calling other functions but none of them works, but when i treid onSubmit("javascript:alert('some text')") it works fine.
I tried debugging it in dreamweaver and i get an regular expression missing error number 1005 on the last line of the javascript.. that is ....
i have the VBScript functions that deals with SQL server 2000.
i have some event handler in the client side Java script. I want to call the VBScript function from this javascript ( on demand). How can i do that? Is it possible??
if this is not possible then any alternative ideas that can execute the VBscript functions on demand from client.
I have an ASP page that calls an Access macro. My macro name is just Import. Actually, this macro is being imported to another DB, which is Information.mdb. When I view the ASP page in my browser, there was an error. Something about database cannot be opened because it is being opened exclusively by another user.
When I go & check in my Access DB Information.mdb, I double-clicked on the Import macro, an error pops up saying "'Itxnrpt Import Specification' does not exist. You cannot import, export, or link using the specification." Code:
I have an access DB that has some queries built in to it.
Rather than putting the SQL in to my ASP Code (which I normally do) I was hoping there is some way to run the queries which already exist in the queries portion of the access DB. The queries do require me to input a variable though.
For example, there is one query called qry_FillForm which required me to pass a value called FormID (number)
If I have the value for FormID in my asp code, is there a way I can simply get this query to run? I can always create a
strSQL string and do it that way, I was just wanting to learn if it is even possible simply call the query that is alreay in the DB without having to manually put the SQL into my asp code.
i am trying to write a function which will add an entry to to a table in my DB and then return me one of the values of the newly added entry.
For e.g. I use the function to add a new Order Entry into the DB, but i would also like the function to return me the value of the OrderID field for the new entry. Code:
I have a neat database running and im trying to place a search engine thro it. I have quite a few tables, BUT i can only get the query in one table. ie Code:
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?
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.
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'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.
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)
