I have a VBScript function:
<script language="VBScript" type="text/vbscript">
Function Main()
set wshshell = createobject("wscript.shell")
struser = wshShell.ExpandEnvironmentStrings("%USERNAME%")
strdomain = wshShell.ExpandEnvironmentStrings("%USERDOMAIN%")
msgbox struser & strdomain
End Function
</script>
That works great as a Active X script but I want this to display as a value in a text field and I can't find how o do that.
I am trying to split a mgrgroup field to extract the MD codes. It correctly grabs the MD codes if all records in a mass update are updated, but if only one record in the loop is updated then it puts the last 5 digits of the mgr name in the MD field.
THIS IS THE CODE: ....
I am using the following code to split/join values in a multi-select field. It is combining all the values in All the records into one long string in each record in recordset.
Example: I have a recordset with 2 records. The 1st contains the split/joined values: Alan Smir, Jeff Karl The 2nd contains the value: Keith Robb
When it updates database, it will put Alan Smir, Jeff Karl, Keith Robb into each record in the recordset. Instead it should be putting Alan Smir, Jeff Karl into the 1st record
and Keith Robb into the 2nd record in the recordset.
Does anyone see what is wrong with the code ....
I need the VBScript equivalent of the Math.ceil(x) function?
View Replies View Related
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 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 to access the form's field in the vbscript written in the same age without submitting the form.
Actually i want to access the ACCESS database to retrieve the records based on the value in the textbox catText.
request.form("catText") is just not working......
vbscript is the default language set up for the pages.
if i create a function in a vbscript then the SERVER objetc is not recognized at all!!!!!!!! How Come?
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 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 RelatedIs there a way to return multiple values from a function without using an
array? Would a dictionary object work better? Code:
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 tried to Display data from field DB (mysql) into a Textarea to edit the text. The code I used is : Code:
<textarea name="warranty" cols="90" rows="6" class="style55" value="<%=WARRANTY%>" type="text"></textarea>
And it does not displays the data.?
I need to display only a portion (like the first 100 characters) of a field in a database. I don't recall how to do this.
View Replies View RelatedI'm trying to make sure that the user inserts data in all necessary fields: for example first_name and last_name fields are mandatory. How can I create a function that will alert the user that these fields are mandatory?
View Replies View RelatedIts purely for aesthetics - not essential but i thought it would add a refined touch.
I want to get an effect where it types the text accross the screen as if it was being typed a letter at a time. For example to write "Hi guys" it would write:
H
Hi
Hi
Hi g
Hi gu
Hi guy...
etc etc but not all on a new line.
I figure this is possible using loops and so on, but to get the effect that I want I will need to make the script wait between printing each letter. Is there a VBscript command for this or will I have to start using ActiveX controls or something?
I am using access Memo field to store text of large size. If I use <%=memofield%> in simple display, it does not look like a formatted field and all text comes in a single line without any break.
Even If the text is same like what I am posting in this thread, out come will not have break in browser's display.
From my system, it allow product has multi-category, so I need to save
all category names which one product belong to into one field on a
database,
and record saved like " nameA|nameB|nameC " - seperate by "|".
question 1:
the second time when i update the record for same product name, how to
have a record
like "nameA|nameB"
After multi-category name saved, then, i would like to generate a
navigate name with the link like
home > nameB > name of product
question2:
so how can i retrieved only one name from category field.
I so thought I had this down and I was getting excited, but when I ran it, it didn't work. I've tried a few different things and I can't get it to work (not smart enough I guess). Code:
View Replies View RelatedI have a timesheet application I'm working on. The user fills in a form which sends data to an Access db. On the results page I need to display the values from 2 fields; i.e if the user selects "Report Writing" from a drop down list, I need the data contained in another column called 'Codes' to display as well.
View Replies View RelatedI know this is a little off topic, but this is the best resource I know of for anything coding related.
I'm needing to read through a text file that will have the following format:
c:ools
c:docs
c:htdocs
And have the the results put in an array for later processing. What I'm trying to build is a small vbscript that will automatically backup each path that may be in a given txt file.
I am trying to change an existing function that currently only displays records that
fall under a criteria of
NOT(now>cdate(OTDate & ' 2:00 AM')
If I wanted to change this function to display entries that are before
6:00 pm the day before the OTDate, how could I modify this part of my
code? should is be something like this...
NOT(now>cdate((OTDate -1) & ' 6:00 PM')
I have a DateTime stamp in one of my Access database columns. Using now() as the default value, it enters records in the following format:
17/06/2005 14:28:40
This is perfect. UK format, just as I want.
However, when I pull this record into an ASP page it appears in a different format:
6/17/2005 14:28:40 AM
How can I stop it from re-writing the data into American format? I just need to display it exactly as it is in the database.
i have a field in my form which auto adds the date to my database, its inputs as 1/09/2007 and what im after is when i retrieve that data to be displayed i would like the date to be displayed as 9th September 2007,
View Replies View RelatedHow would I get the max record + 1 to auto-populate in the GMVINC form field? I have a feeling that my query is not correct. Code:
View Replies View RelatedI need to parse a string from a single, semi-colon delimited, 60 character
field (el_text) in a recordset and display the results in a table on a
webpage (ASP)
I can retrieve the recordset from the database and display the field data
results in rows of a table but have the entire 60 character string in one
cell. I need to break that string apart and put each semi-colon delimited
value in it's own cell. Then move to the next record and do the same thing
in the next row of the table. - and so on
I'm using ASP, VB Script with DMSII Database and OLEDB
Does anyone have some code examples on how to break this field apart and
then arrange the data into an html table on a webpage?
is there any one know how to make function to update db field and to be called on checking a check books.
View Replies View Relatedi had a vbscript that will read the text file from the bottom to the top, and after reading the file, it will be displayed in the screen, and the code look like this:
PHP Code: Code:
Can anyone tell me how to display just the first few words of the data. For example:
The full text:
Hello, how are you? What are you currently doing and hope you have a good day. Merry Christmas and A Happy New Year.
I just want to display:
Hello, how are you? What are you currently ...
I am not very familiar with the asp coding for displaying part of the message.