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 RepliesI 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?
There 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 RelatedI have a page that has 5 different functions, each function has it's own recordset and database connection object variable like this: Code:
for function 1
objRs1
objCn1
for function 2
objRs2
objCn2
etc...
is this even necessary? Do I need separate variables like this inside the function?
i'm starting at ASP now and I'm searching some information about it. For example, I need to know all about Application object. Some oficial documentation where I can find it?
View Replies View RelatedDoes AnyBody know how to run windows functions in ASP? I want to run the function GetSystemMetrics From ASP and i don't know how i can do it. in VB i know to how to declare windows functions and how to use them, but in asp the script didn't work.
View Replies View RelatedWhat I'm trying to do is write a small download manager / tally thingy. I have it mostly figured out how I'm going to do it, although I need to be able to scan a folder for files that have not been entered into the database. (Thats the problem) does anyone know how to do this ?
View Replies View RelatedI am having a problem with the following code:
<%
If Len(TestRS.Fields.Item("Testimonial").value) > 150 Then
Response.Write(Left(TestRS.Fields.Item("Testimonial").Value,150)&""... <br><font size=1><a href=""/Testimonials.asp"">Read More</a></font>")
Else
Response.Write(TestRS.Fields.Item("Testimonial").Value)
End If
%>
I am getting a null response from TestRS.Fields.Item("Tesimonial").Value after it is processed by the Len function.
I am getting the following result: Quote: "... Read More This tells me that the len function is analysing the string to be greater than 150 charachters yet the string is not being expressed.
Is it possible to perform functions on a recordset (rather than on the
source database), e.g. COUNT, MAX etc
The reason I would like to do this is because I have a hugely complex view
which produces results with over 60 columns of data. I would like to display
all data but also highlight individual "cells" in the table which have the
highest (i.e. MAX) data for each column. I would also like totals at the
bottom of each column.
Obviously I could get the MAX value for each column by performing it on the
SQL data but that would effectively mean running the query twice and would
take twice as long.
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:
Is there any functions like chrB in vbscript that returns the byte associated with the ASCII code in jscript. If not how we return a byte. The code in vbscript is ChrB(Asc(Mid(a charcter))). Please tell me how we convert this code to vbscript....
View Replies View Relatedwhat are some simple fuctions, like how do i get the date using mssql. also wheres a good tutorial on mssql
View Replies View Related