Returning Multiple Values From A Function

I've looked around the net and searched this message board and haven't been able to find a solution to this problem. An application that I am currently making pushes and pulls data from SQL. One stored procedure is very important and returns many values.

I call this sp many times in my script and wanted to put it in easy to manage function, sub, or whatever works. The problem is that it returns about 10 values that I would need to return from the function back to the standard asp. Code:

View Replies


ADVERTISEMENT

Returning Multiple Values From VBScript Function

I am using both VBScript and JavaScript functions in the same ASP file. All I need to do is to retrieve some values which are calculated in the VBScript function, to JavaScript. The call to the VBScript function is made through a JavaScript function. Code:

View Replies View Related

VBScript Function Returning Multiple Values

Is there a way to return multiple values from a function without using an
array? Would a dictionary object work better? Code:

View Replies View Related

Returning Values - Which Is Faster? ByRef Sub Or Value-returning Function

What is a faster/better coding practice?

Method 1:

Code:
Sub myFunction(byRef x)
x = x + 1 ' do something with x
End Sub

x = 7
myFunction(x)
response.write x ' shows 8
Method 2:

Code:
Function myFunction(x)
myFunction = x + 1 ' do something with x
End Function

x = 7
response.write myFunction(x) ' shows 8

Also discuss considerations when there are more than one variables that need to be changed.

View Replies View Related

Sub Returning Values

I was under the impression (according to all the tutorials) that a Sub differs from a Function in that it doesn't return a value. Therefore I interpret this as meaning if a function is initialised at the top of a page and called at the bottom the result won't be returned to the place it was called i.e. the bottom of the page.

This clearly isn't right though as both Functions and Subs return a value to where they are call from.I want to display the results of a task in a position on the page that is before the task has been carried out.

Therefore if I create a Sub where I want the result to be displayed I assumed that when I call the Sub it would display the results where I wanted i.e. above the task. This isn't happening?

View Replies View Related

Returning Values From Functions

how do i return & pass values in functions as i have been strugling.

View Replies View Related

Returning A Value From A Single Function

I would like to know if I can some set a variable to return a single value
from a function using the set command. Is this possible? Code:

View Replies View Related

Returning A Recordset In A Function

I am having some troubles returning a recordset in a function. function: Code:

View Replies View Related

Returning The Results Of A Function

I have a function displaySiteMemberName(varSiteMember) that pulls the name of a member from the database. I also have a function displayThreadComments(threadID) which displays a little text and then the members name.

However, I can't get it to display on the same line. I'm assuming that its a problem using the response.write but I don't know how to return a value from a function. Code:

View Replies View Related

Closing Objects After Returning Value In Function ??

I am maintaining some code and I see in some functions..

Function myFunction

set someobj = Server.CreateObject("MYOBJ")
.....
....
set myFunction = "somedataToReturn"
set someobj = nothing

End Function

View Replies View Related

Multiple Values

How do I pass in more that one variable in the form tag below
code:
<%
Dim CmdPopulatelist
Set Conn= Server.CreateObject ("ADODB.Connection")
Set CmdPopulatelist = Server.CreateObject("ADODB.Recordset")
%>
.
.
<% sql_select= "select * from Patch_Feedback where Patch_name= '"& view_name &" ' and Name_of_user = '" &Name_of_user &"' " %>
<%
Conn.Open "DSN=Patch;uid=cmadmin;pwd=dci01;database=cm_db"
Conn.execute(sql_select)
CmdPopulatelist.Open sql_select, Conn
%>
.
.
.
<form method ="post" action="updateresponseA1.asp?update_ID=<%Response.Write(""& CmdPopulatelist ("Patch_ID") )%> ">

View Replies View Related

Allow Multiple Values

I have code that is looking at the userlogin name and then assigns them to a certain value, thereby allowing them to see certain groups of reports on a website. If I want them to have multiple values, how would I code this? This is what I have so far:

if strUser="jdoe" or strUser="jsmith" then

View Replies View Related

Multiple String Values

how can I compare a values to multiple string values. i.e.

If Request.ServerVariables("REMOTE_ADDR") = "213.123.214.33" Then
WriteLine "A problem has occured, please email for help<BR>"
end if

Would it be to do multiple if the elses, case or can you put all the possible values on the one line? i.e. "123.123.123.23" or "345.234.234.234" etc.

View Replies View Related

Insert Multiple Values

I've a multiple checkboxes and would like to insert those values into the db. How can we insert all those checkboxes’ values into 1 field (DB), we use a stored procedure. This is urgent

View Replies View Related

Multiple Values In One Field

how do i insert multiple values into one database fields using ASP.

View Replies View Related

Multiple Values From QueryString

how i could put multiple values on to a Query String and get them on the next ASP page. Currently on wy website, i know how to get one, but i am not sure how i am able to get more than one assigned to a specific variable.

View Replies View Related

Passing Multiple Values

I have a link as follows:

<A HREF=""Tracker.asp?MovementID=" & RS("MovementID") & " PONumber=" &
RS("PONumber") & """>" & RS("MovementID") & "</A>

I am trying to pass: MovementID & PONumber.
On linking to Tracker.asp,

MovementID = 2257 PONumber=21071045
PONumber = Empty

I am just testing this with Request.querystring. What have I done wrong, how can I separate these values ?

View Replies View Related

Multiple Queries And Using Their Values

I am running two queries on a single page and they essentially work, the only problem is that i am unsure exactly how to get one aspect to function properly.

To explain it correctly it will probably be easier to just show you the code, the first query looks like this: Code:

View Replies View Related

Using Replace() For Multiple Values

is there a more efficient way to replace multiple values than this (so that the numbers 0-9 are placed with particular texts in one go): Code:

View Replies View Related

Displaying Multiple Values

how do get ASP to display multiple calls from a database? For example, I can name a variable for a password, then query the database, then call the password variable later in the code and it should display the password from the database.

Code:

strBody = "Here is your login password: " & strPassword

If in the body of this message I want to have a username on the next line, how do you do this in code? I thought you used a &vblt command, but that throws an error.

View Replies View Related

Request Multiple Values

i've got 7 radiobuttons with the same name, but them values are different. I need to request the checked values and insert in my field on the database, but how can i get do this separated ones?

<input name="idioma" type="checkbox" class="campo" value="1">Portuguese
<input name="idioma" type="checkbox" class="campo" value="2">Germany
<input name="idioma" type="checkbox" class="campo" value="3">Russian
<input name="idioma" type="checkbox" class="campo" value="4">Spain
<input name="idioma" type="checkbox" class="campo" value="5">French
<input name="idioma" type="checkbox" class="campo" value="6">English
<input name="idioma" type="checkbox" class="campo" value="7">Italian

Can anyone Helps me?

View Replies View Related

Retrieve Multiple Values

I have some problems in trying to retrive multiple parameters from a stored procedure. When i want to just get one i use

select @param AS 'para'

But how should i do when i want multiple parameters out to the ASP files?

View Replies View Related

Multiple Page Values

i want to submit 30 field(textbox,combo etc.) data into database.if i take all 30 fields on same asp page or form,the page will not look good, so i want to break that into 3 pages,each page will having only 10 fields.when all required fields on first page will be filled by the user then he will click on next button,so he will see next page , i.e. page no. 2,same for page 3.

if he want to come on previous page for editing some info,it should be possible.on 3rd page there is submit button,when he clicks on submit all the info will stored into table. can anyone tell me is it possible using ASP 3.0? if it is possible then tell me how to do this?

View Replies View Related

Return Multiple Values

At the moment, the function looks like this:

code:
public function fncGetPageContent(intSectionId_In)
set rsPageContent = connection.execute("SELECT TOP 1 * FROM sections WHERE section_id = " & intSectionId_In & ";")
if not rsPageContent.eof then
strSectionCopy = rsPageContent("section_copy")
strSectionTitle = rsPageContent("section_title")
end if
rsPageContent.close
set rsPageContent = nothing
end function

My question is, how do I call this function and return the two distinct values?

View Replies View Related

Send Multiple Values

I have a stored procedure that requires one variable to be filled: WHERE ItemNo = @ItemNo
Instead of sending 1 value,I'd like to send a bunch of values. I don't mind changing the SP if I new how to approach this. The user would select any number of ItemNo's from a form and submit.

Assume ItemNo's like: B1, B2, B3, etc...
The end result would be something like ...
WHERE ItemNo = B1 or ItemNo = B5 or ItemNo = B10 ...etc....

I want to build a recordset based on the user's selections. How?

View Replies View Related

Submitting List Values To A Function

I have a list box with five values in it. These are essentially account groups. The user will select one of these values and click on a button. This will update a second list with specific account names depending on what the user selected on the first list.

These account names will be retrieved from an SQL database. Below is the code which sets up the first list and the button. Code:

View Replies View Related

Problem With Len() Function & Null Values

i've come across a real head-hurter. I'm looping through a recordset and
response.writing it's rows out with no problem except 1 field. The field
type is varchar and contains words like meeting, holiday, etc.

Problem is, I'm trying to render a "n/a" when the field is null as in
LISTING 1 below. My code isn't catching the null values. How can I test for
null values? I could swear I've successfully used the Len() test like below
successfully on similiar null varchar fields, but perhaps not.

Any ideas?

LISTING 1:

If Len(objRS(7)) < 1 Then
xTeamName= "n/a" ' this is problem line
Else
xTeamName = objRS(7)
End If

View Replies View Related

Passing Optional Values To Function

How can i pass optional values to a function? I tried this below which gave me an "Expected identifier" error:

FUNCTION cart_state_list(selectname, optional stateid as integer = 1)

If it were php here is the code

function cart_state_list($selectname, $stateid = 1)

View Replies View Related

Multiple Values For Radio Buttons

I have a form on a web page with a number of radio buttons bound to
the same field. Is it possible to set up the form so that users can
select more than one radio button to submit multiple values to a field
in the way that you can, for example, in a drop down field?

View Replies View Related

Multiple Count Function?

I am having problems trying to figure out or if it is even possible to do this.

Here is my records:

1=New
2=Open
3=Closed

Table stats
ID, Status
1 1
2 1
3 1
4 2
5 2
6 3

So I am trying to count each of the status

So Total records should be 6, New 3, Open 2, Closed 1 records.

SELECT COUNT(*) FROM Stats

Thats about all I know on this, will give me the total. but is there a way to count the total and count individuals.

View Replies View Related

Post Multiple Values For One Form Field

I loop through a recordset to return values that populate a form which
the user can then edit and save. However these fields need to be validated first
to make sure the data entered is correct. I have a Firstname field that returns 3 records
from my recordset which means when I try to validate, I get an error as the page doesn't know which of
the 3 to use. I believe I have to do it through an array, but have no clue how as my efforts have failed

View Replies View Related

Freeaspupload: Retrieving Multiple Values From A Select Field

I'm having problems retrieving all the values from a multiple selection field using the freeaspupload component.

I'm creating an online email app that uses the freeaspupload to add attachement functionality, which means the form encoding type is multipart/form-data. I've done something similar with the persits aspupload component, and had no problems with that, but the freeaspupload version seems to handle <select> fields slightly differently. Code:

View Replies View Related

Retrieving Multiple 'values' In A Single OPTION ITEM

I have a difficult technical challenge I'm facing. I need to retrieve multiple values for the very bottom item in the list, 'Federated' (ignore the rest).

The database will query based off the option 'value', however, in this special case I want to perform a retrieval based off of multiple of values. I want to try to use the existing code without reinventing the wheel. Code:

View Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved