I'm dividing two variables and on some instances the results going to be a long decimal. I want the decimal to round up to only one pace tho. How could I do something like that? My coding looks like this.. Code:
readscore=rsgameinfo("readerscore")/rsgameinfo("readervotes")
I have a page pulling some data from an MS Access DB, one of my columns is a "Application" column.
I have a dynamic dropdown pulling various Application names from a separate "Application" table in my DB. What I'd like to do now is to be able to select one specific Application from that dropdown and click the GO button to have it only show records with that Application name in them. Code:
I have an ASP project where I have users select or input values into a criteria page and then once they press "Submit" the ActiveX viewer displays the crystal report. All works fine and the criteria can be somewhat dynamic because the variables are used to build a SQL statement that is passed to the crystal report as the dataset.
What I would like to do is create a variable on the Crystal report that will display the SQL statement or at least an English translation. This variable will be used to display the criteria of the report so end-users can see what criteria was used to generate the output of the report.
I want to pass a variable by way of a querystring (or any way that's possible) from flash (actionscript) to vbscript. From there I want to save the variable into a MySQL database. I understand the vbscript part but how would I transfer a querystring from a flash program to vbscript?
View Replies View RelatedThis is my VBScript function:
<script language="JavaScript" type="text/JavaScript">
Dim UN
Set objNet = CreateObject("WScript.NetWork")
Set objUser = GetObject("WinNT://my domain/" & objNet.UserName )
UN = objNet.UserName & " (" & objUser.FullName & ")"
</script>
How can I reference the VBScript Variable UN in my ASP code? <%=UN%> won't work because VBScript is on the client side and ASP is on the server side. If I have to post it on one page and read it on another, how do I do that?
I have the following code in an ASP page but it does not seem to allow a JScript to access VBScript variables. But if a VBScript accesses a variable in declared in a JScript TAG then it seems to work.
<SCRIPT LANGUAGE ="VBSCRIPT" RUNAT="SERVER"
Dim tes
test = 10
</SCRIPT><SCRIPT LANGUAGE ="JSCRIPT" RUNAT="SERVER"
Response.Write(test)
</SCRIPT>
I tried the search function but I can't really identify what this kind of issue would be called (Searching store variable comes back with hundreds/thousands of hits).
I am doing an update form which opens 2 SQL connections (its easier for me to do this cause I mess up joins to a significant degree, that and performance is not a big worry, eitherway).
<notes> Both connections are open, one is called rs, the other is called articlers. I have 2 databases (named database1, and database2), and I have two different SQL strings (SQL and articleSQL, the problem comes in the 2nd string and in storing a variable. Code:
<%@ Language=VBScript %>
<%
dim a
dim b
a=11
b="11"
if a=b then
Response.Write "a=b"
end if
%>
But can't shows "a=b".How can changes variable type?
I have an input box when the user clicks on the button.
var number=prompt("enter journal number");
How is it possible to pass this variable forward but to vbscript? So i could use that variable in an sql procedure?
I have a Function in VB Script that generates a signature. I assign the result to a variable and then need to do a hidden post to an ASP Page for further processing.
Basic functionality is I have a button upon pressing it -- It does the hidden post.
Code looks like this. Please assist with passing this stringToSign variable to the .asp page via hidden post. Code:
I want to use vbscript to run a script multiple times and save its results to a text file. I have practically wrote this script before but only using a sql command wrote in to the script. However, this is a lengthy sql file so can not be directly entered in to the vbs script,s o I would like to run it using sqlcmd.
"SQLCMD -S "&WScript.Arguments(0)&" -i "&WScript.Arguments(1)
I have tried Googling this problem but found very little information about it. Any discussions online that I have found show no code and assume you already know how to do it.
I have found this so far:
Set objShell = CreateObject("WScript.Shell")
Set objScriptExec = objShell.Exec("sqlcmd -S "&WScript.Arguments(0)&" -i "&WScript.Arguments(1))
But how do I get hold of the results in to some kind of variable?
Is there a way I can assign a value of true or false to a VBScript variable? I have a function where I want to initiate a value of false: Would this work? Code:
View Replies View RelatedI'm turning my application into a "DLL". Everything worked fine untill I try to do a "While" in my asp code. Then I recieve an error like this:
"Object variable or With block variable not set"
My vb code look like this.....
is there any way of passing a javascript variable over to a asp variable so
i can write it to my database.
How can I make a ASP-file to a .DLL? The idea is to protect the source from others who use the same IIS. Can I make a ASP-file that calls a .DLL - file with all functionality, or how does it work?
View Replies View RelatedHi does anybody know if you can make a form
have two actions and how?
how to format the table in order to show 23,567,987 instead of 23567987 , I mean it's very hard to read when there are more than 4 digits.
View Replies View Relatedwhen you click on it to go to the off site the user name and password will be automaticly inserted to where the offsite is asking for the name and password.
My company deals with insurance companies and we would like to make it to where when our employees go to our intranet and click on a link to one of our carriers it will have the name and password in place for them. i heard its possible and old company did it but I am having so much trouble trying to figure this out.
Its the first time I use ocx on my asp pages. Say I have an ocx which is a dropdown with multiple columns. Before its displayed, I call a method to populate the pulldown, so how do I make the script block talk to the html?
'script block
<%
dim myObject
set myObject=server.createObject("myObject.pulldown")
myObject.Populate(.....)
%>
'HTML block
<Html>
<OBJECT ID="MyObject1" CLASSID="CLSID:12345678-8AB4-4230-A65E-DA15A40F9900"></OBJECT>
I want to know how to make a match for a text , for I'm wan't to search for this in the db . the search i made search only for the exact text user inserted so if the user misspelled the word the search will give him zero result. So i want to seach for any part of the word or if it is aword in aphrase.
View Replies View RelatedWhen you hover over one of the topic in this forum a box appear with the first few lines of the message in it. How is this created. What events area used to creat something similar and does anyone know of any good website where i can look at a tutorial for it.
I dont even know what they are called so dont know what to search for even on the web as if i write pop up i get something else which i dont think is what i really want to use, or maybe it is.
how to make the session timeout. and where should i put the session timeout.
View Replies View RelatedI have Windows 2000 Server. Running IIS 5. I created a ASP file that connects to a database and when i go to view it, It either says that there is a error in the code on like 106.
Which is only an "End If" command, Or it will say that this page needs to be posted on a web server that supports ASP. Well.. I have indexing service running, And I know for a fact that the code in the page is correct because it works on other 2000 server.
I have a webapp. that holds a lot of documents. Some of the documents needs to be produced from a database on-the-fly, some are static documents like PDF, Word documents, etc... In the end, a user can do a request to produce a large amount of documents as one huge PDF document. Today the creation of documents is working, but all code is done in ASP.
In Visual Basic, I was thinking about making an ActiveX EXE server that generates the PDF document. The ASP page will be polling until the file is generated. When this is done, the file will be displayed. I have only written down my thoughts on the subject. Is there a good way to do this?
how to off the html in the textarea or text box. so if user write an html code in textbox or textarea , would.nt make the page changes. like this add thread how about if i wrote an html like </table>, it will make the display page change.
View Replies View RelatedIs it possible to make a cookie NEVER expire? or not?
View Replies View RelatedHow to use asp to populate checkboxes from a column in an Access table? I want them to be updated when the table is updated.
View Replies View Relatedis it possible to do a insert, add, and a redirect all on the same page?
for example... signup.asp. there's a text box labeled Acctid. If you don't have an acctid please enter "0000" otherwise enter one. This box is used to see if they have an existing account in the database by using an UPDATE query and if they don't it does an INSERT query with acctid = 0000 for all non customers. What I want the if.then.else statement to do is to
If acctid = "0000" then
conn.execute acct_add
(and if sucessful to response.redirect "/yay.asp"
Else if NOT acctid = "0000" then
conn.execute acct_update
(but I want it to return an error if the update wasn't sucessful either because the acount doesn't exist or watever and if the update was sucessful to response.redirect "/yay.asp") END IF
Do ya get it?
I got admin's pages and users pages. If I haven't logged in as an admin first and i'm either not logged in at all or logged in as an user then when I try to enter an address of an admin's page then it redirects the user to the main page.
I tried solving the next problem with cookies andor with session but neither of them worked. Code:
i have this
Response.Write Replace(Rs("Event_Details") & " ", vbCrLf, "<BR>") & vbCrLf
coming from access db.
how can i get that to make a hyperlink clickable as well??
I am looking to make my company's access database (forms, reports, etc) available through a web server. Any idea what type of programming will be needed (ASP, JSP, PHP)? If there is anyone that can help me with this please let me know. I am willing to compensate them for their time and help. It should be a fun project.
View Replies View RelatedI would like to make a database that contains Picture, Name Job description, gender and web address. The database should be able to hold at least 1000 profiles.
What program would you sugest? Where do I get it? Are there any online tutorials you would suggest?
I am developing an ASP page for clients. I will host the page on my
server, but it must appear on the clients' websites. That means that
the user should not be redirected to my site, but instead should remain
on the client's site. Or at least appear that they are remaining on the
client's site.
One thing that would be acceptable is to host the page on the client's
site, but have it hit my site to get the data. I have looked into
XMLHTTP and also just having the ASP page hit a remote SQL Server
instead of a local one, but haven't made any decisions yet.