Basically, I have an asp application that uses a database connection,
and I want to declare (create) that connection in an include and use it
throughout the application in various functions. I've tried making the
connection object a public variable, a constant, making the functions
public, passing the connection object in byRef, byVal, etc... I just
can't get it to work. Is this not possible in classic ASP? Code:
Does anyone know of a way to enumerate the local variable scope? The
reason I ask is that I have a function that dumps the contents of
response,request,server,etc... for debugging purposes. I'd like to also
display the local variables.
I created a ADODB.Connection object in Session On_Start and tried to connect to the databse On_Start. It is giving errors. Can't have a connection opened only once in a whole applicatio like VB.
The Con variable is available for the whole session but the connection state is not available for the whole session. Do I need to open a connection everytime I want to access a database????
I have problem regarding cookies collection in response object. the senario is. I have created a cookie on signin page using:
Response.Cookies("username") = "userid"
If i print the value of cookie on this page then it shows me the correct value.
when i print the value of this cookie in another page using response.write request.cookies("username")
It doesnt print any value.
I have checked for every security problem in my internet browser but havent got any result. i am using internet explorer 6.
I am making a testing project to get my hands on ASP classic. I have a question about Global Scope Variables e.g in PHP we make a file where we define some values which are global, e.g site URL, site title etc, and then we can include that in any page to get that value.
I read Global.asa works very good in fact we dont need to include that in every page to use stuff within this file. I read some examples but they are mostly about functions in this file. Can anybody guide me please how to define variables in Global.asa to use them sitewise?
There are many web sites on the server - each has a virtual directory pointer to a common directory containing frequently used routines. Scripts run from the virtual directory appear to have no access to session (or application) variables. Is this expected behaviour? Or have I yet to track down a bug?
View Replies View RelatedI have a piece of vbscript that returns the user logged on to the machine. it is as follows:
<script language="vbscript">
Set WshNetwork = createObject("WScript.Network")
stringUser = (WshNetwork.userName) 'store username in variable stringUser
document.write("Username: " & stringUser) 'output value to web page
</script>
Now I need to use the value of stringUser on other pages of my asp application for database queries, form values etc. I have tried to call stringUser from inside <%..........%>, but it doesn't recognize the variable. Everytime I try to output the value from wthin asp code, it just appears as blank space. Any ideas?
This has been puzzling me for very long time and no where has
talked about the scope of a 'On Error Resume Next' statement.
When we program ASP(.NET) pages then we usually like to let
ASP(.NET) stop at errors and report back to us. However there
are parts of our scripts that we know an error will be thrown
and we encapsulate that area inbetween:
On Error Resume Next
Err.Clear
'Try block
If Err.Number Then
'Catch block
End If
On Error GoTo 0
This is similar to the infamous try {} catch(e) {} blocks in
Java/C++, etc.
If we forget the last line 'On Error GoTo 0' then our ASP(.NET)
scripts runs over all errors thrown and we find it hard to
find bugs. So the big question is, does 'On Error Resume Next'
go out of scope when it's written inside a block
(eg. Function)?
Function Function1()
On Error Resume Next
'Our code
End Function
When the Function1 call returns, does the outside calling scope
automatically stays as it was (On Error GoTo 0)?
How can I give a user-defined object session scope? From
http://www.microsoft.com/windows200...asp/iiwaobu.htm
I gather that it can be done, but there are no examples. Simply setting
Set Session("tag") = new MyClass
doesn't work.
I have a file i created
it contains several functions, and some other code to build a string based on diffrent vars.If i run this file standalone, it works absolutly fine. However the problem comes when i include it half way in another script.
I get the following..
VBScript Error 800a03ea
test4.asp, line 2 function encr..
This is line 2
Function Encrypt(Message, EncryptionKey)
I am searching for a function that can separate a string var to some string vars and devide the string by "," marks, os this possible?
example:
str1 = "2,34,1,54"
and I want "2","34","1" and "54" be devided and inserted into new vars, or an array var, is their a VBscript function for this?
I have made a function myself that does this using ths Instr and the Mid functions, but its quit messy and I don't wan't to have to insert it in every page I make, Any Ideas?
Another small thing, I want to learn how to use Classes in ASP, I don't know what to look for exactly, (vlince, I could use a link now...)
<%= functionName(value1, value2) %>
Trying to call a function which returns the modulo of two numbers, can l simply whack the function name in and the value will be returned ?
I've written the following function but somehow the output is not what I want it to be. Can someone explain to me what i'm doing wrong?
function fn_piping(inputWaarde)
outputwaarde = inputwaarde
Response.Write outputwaarde & "<BR>"
if i = 1 then
i = 2
call fn_piping("thisshouldbethefinaloutput")
else
fn_piping = outputwaarde
end if
end function
i = 1
figure = fn_piping("bla")
Response.Write "<BR>" & figure
So 'thisshouldbethefinaloutput' should be the final output, but it doesn't output anything?!
I need a current record in the database for it to work but I have another page that uses this same code and it works fine on that and the only thing different in the coding is where the information is being pulled from in the database and when i first copied & edited the page it worked fine but now it doesn't and i've worked on it .....
View Replies View RelatedI would like to call a asp function when i click a button in a form. I'm using VB. I know in Javascript it the onclick event is there a similar handler in VB????
View Replies View RelatedWhere'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)
i am wondering how to actually get the month in letters..... i have used a
strMonth = Month(Date)
but it is returning a number of the month... i would like to make this the actual month such as January, August, etc.... how would i go abt doing this in ASP.....
Over my years developing ASP applications and writing asp code in general I have created a library of nice little apps and functions that I use over and over again.
I was "thinking" about maybey setting up a site with all my useful functions, subroutines, and possibly applications for people to download and hopefully donate some money if they use them. Perhaps even have some apps for sale only.
The apps will mainly be my useful plugin developments such as guestbook, gallery, login system etc. My question however is do you think it would be worth the time and effort? Do you find yourself using plugins a lot?
I defo think the functions could be handy but again how many of you search for functions to help you out or indeed how many of you currently use functions you have gotten from other people? Would you donate something if you used them?
Mayby some of you have already done something like this and can let me know how you got on?
Didn't remember if anybody had started started like this, but I decided it would be cool to start it again. If you have a math function request ask it below, or if you have made one then add it:
I have a few cretegean plane (think thats how you spell it), calculations. One request I have is, does anybody have a short function for square root?
I have some code I am working on. One function reads a file using fso, then
I have multiple functions using the string read from the file. Each
function splits the lines up and will return one value.
Is there a better way? Is handling this many array which are basically the
same going to cause some server distress
I know there is the function IsNumeric() in ASP and we have a SUM function in SQL, but why don't we have the following functions in ASP:
Code:
Sum()
IsAlphabetic()
I have been developping a webpage in ASP for about 4 weeks now and I have noticed that I am rewriting similar functions in pretty much every page i make. So I was wondering if there is a way to make some particular functions global so that you can use them in any page. The functions will depend on the session id, but I don't know if i can declare session functions or not.
View Replies View RelatedIn this function i pass variables to it to find out if a record exists, what i want to do next is call this function and if a record does not exist pass a variable out like Statement = False and then pick up that value on the page that i call the function.
Can this be done? I was thinking perhaps using a Session? Code:
So i am inserting Now() or Date() (Either one will work for what i want), into one of my fields.
But it is returning the Server time, which is about 17 Hours behind of what i want. Is there anyway to insert Australian time, as in where i am situated?
I'm a PHP programmer. That said, I recently began a job where a good third to half of the applications are written in ASP.NET. VBScript, to be precise. As I've done programming for years (C/C++, PHP, JavaScript, BASIC... the list goes on and on), picking this up hasn't been too difficult, but I now find myself facing a question that I simply cannot find an answer to anywhere:
Can one define a function that has optional parameters in VBScipt?
If not, can it be done in C#, and can C# code be easily integrated into pages written in VBScript?
I have written a very complex web app for intranet use. It allows users to search a large database and then returns formatted results. I am currently employing a method as below: Code:
View Replies View Relatedif there was a function in ASP that checks a date to see if it is valid or not. I am aware of the IsDate function, but I think its not what I'm looking for. I want to run the following date through a function and have the function tell me that it is
invalid: 31-Feb-2003 (cos there is not 31 days in Feb).
Or a good way to make my own function?
I have a function called GetRS which takes in a SQL string and returns a recordset object. Does this mean that a copy of the recordset is returned or is it passed by reference?Obviously this could have a large impact on performance for large recordsets.
View Replies View RelatedThere is a chapter on SUBROUTINES, FUNCTIONS AND INCLUDES.what is the difference between SUBROUTINES and FUNCTIONS. If not mistaken, in VB, the SUBROUTINES return no value, but FUNCTIONS do have return value.Variable in ASP: global versus local.variable not in betweeb function is Global (what about subrountine, is it the same) and variable in between function is local, am I right?
View Replies View RelatedI have a column in my SQL server database table by name request_generated_date of datetime datattype and the default value set to it the server date by using the function getdate().
I am querying this table wherein I want to check that when a user submits a form then it should check the following: the submit date (column:request_generated_date in the tabel)should be less than the server date + 24 hours (or one day). When I am writing the query as
where request_generated_date ='"&dateadd('d',1,date())&"'"
but the result set is empty.Can I use the date() function in ASP or not. or should I try to remove the time factor from the server date and then query the column.
I've got a page displayin a CV and want to have two buttons, one to display the page in printable format and show the print dialog box and the other as a Save As button to show the save as dialog box. does anyone know the two javascript functions.
View Replies View RelatedI have a form that collects the following article information:
title (input type TEXT)
publication date (input type TEXT)
source (input type TEXT)
article text (TEXTAREA)
When I put something like the following sentence into the text area, it's screwy):
The dog's were the perfect "matched" perfectly. I'm using SQL Server 2000. how I would use replace functions to:
1. insert that into the db without errors
2. extract the information with single quotes and double quotes like it should be read.
I am getting into using functions and am trying to design generic functions which i can use throughout my site. Is is possible to store a + or - inside a variable so that i can make my function cope with subtraction and addition?
View Replies View Related