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 RepliesIs there a way to return multiple values from a function without using an
array? Would a dictionary object work better? Code:
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:
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.
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?
how do i return & pass values in functions as i have been strugling.
View Replies View RelatedI 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:
I am having some troubles returning a recordset in a function. function: Code:
View Replies View RelatedI 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:
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
I need the VBScript equivalent of the Math.ceil(x) function?
View Replies View RelatedI'm getting an error on my ASP page:
Microsoft VBScript runtime error '800a000d'
Type mismatch: 'StoreFileIntoField'
I assume - 99.5% - the error is generated because of worng value types,
I attemp to pass from my ASP/VBScript page to the VB/DLL function.
My relevant ASP/VBScript Code is: Code:
I am struggling to call a vbscript fn from my form (in asp page)
My code looks like below:
<input name="b1" type="button" value="Update Status" onClick="test()"/>
<%
Function test()
msgbox "hello! how are U?"
End Function
%>
Any tips on how I can make this work?
What is the syntax for calling a VBScript function from a hyperlink ?
View Replies View RelatedI''ve 3 to 4 or more combo boxes. On the change event of the combo boxes I want to fill the values.
Suppose I change the value in combobox1 the second combo box should get filled basing on the first combo box, in the same way the third combo should get filled basing on the second combo criteria and the fourth combo should get the values basing the selection made in the 3rd combo.
All the combo boxes are fired in the change event of the combo box. And please no Javascript only VBSCRIPT.
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") )%> ">
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
i have a problem statement like this:
<%
sub test()
---------
end sub
%>
<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().
Math.ceil(number) is from JavaScript. Is there a VBScript analog?
View Replies View Relatedhow to modify a function like this to specify the new window size? I'm able to specify window dimensions easily using window.open in javascript, but am at a loss for how to do it using this vbscript method. The 'strtext' are ASP recordset values. The page the opens in a new window is a map service.
<SCRIPT RUNAT=SERVER LANGUAGE=VBSCRIPT>
function mapLink(strtext)
on error resume next
mapLink = "<a href=""http://planning/ims/tpViewer/?Query=SDE_ADMIN.TP_AREA.TIMEPOIN_1%20%3D%20%27" & strtext & "%27&MapUnits=FEET&ActiveLayer=0&QueryZoom=Yes&Tools=Yes"" target=""_blank"">Map</a>"
End function
</SCRIPT>
I'm trying to call multiple asp page just simply by clicking a button But could i do this method? or how could i pass the value from this page to another asp page.
It should be something like this:
<SCRIPT LANGUAGE='VBSCRIPT'>
<!--
function btnClick_onClick
document.form.action = "myform.asp?ID=" & document.form.txtfield.value
document.form.submit
End Function
-->
</SCRIPT> ...
I would like to call a javascript function using vbscript. Is this possible at all? If so, what should the code be?
View Replies View Relatedhow 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.
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 Relatedhow do i insert multiple values into one database fields using ASP.
View Replies View Relatedhow 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 RelatedI 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 ?
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:
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 Relatedhow 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.
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?
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?
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?