Can I call a value from the database to javascript/vbscript. Let's say the database is called SQL="SELECT * from checkout".Can I validate that the SQL and the javascript/vbscript equals to each other and inside the javascript uses the response.redirect function to another asp page?
View 3 Repliesselect sum(amount)as Total from studenttbli have wriiten above query ,now i need that amount sum in vbscript variable. i m not able to write tht i have written folowing but it is showing errortotal=sum.filed("Total")
View 1 Replies View RelatedI have a table with a list of games in rows. I want the user to be able to close/hide the game they don't want to play. At the moment I am using this;
Code:
<script language="JavaScript" type="text/JavaScript">
function removeR(r){
r.parentNode.removeChild(r);
}
</script>
<table>
<tr>
<td>Game 1</td>
<td><input name="button" type="button" onclick="removeR(this.parentNode.parentNode)" value="Close" /></td>
</tr>
<tr>
<td>Game 2</td>
<td><input name="button" type="button" onclick="removeR(this.parentNode.parentNode)" value="Close" /></td>
</tr>
<tr>
<td>Game 3</td>
<td><input name="button" type="button" onclick="removeR(this.parentNode.parentNode)" value="Close" /></td>
</tr>
</table>
This hides the games the user doesnt want to see on the page. But before the game is hidden I want to make an Ajax call to the database and add the user's preference into the table so next time the user comes to the page I can hide the game from the start. How can I do this?
I have a js file located on domain A, and on domain B i have included the js file, i want to change some information within my js file depending on the url(pulled from a database). I already have pulled the url via some coding and I am wondering if I use Ajax on domain B will this actually pull the information or will it stop it because of cross domain security? If it will block it, how can I pull this off?
View 9 Replies View RelatedI am mixing javascript and php to graph sales dynamically from a mysql database - unfortunately i can only plot 1st sales value - i basically need javascript to call a php function that queries the database and returns the next sales value - here is a snippet from the php file [code]...
View 2 Replies View RelatedIs it possible to call a WSDL document behind authentication with an existing SOAP service to pull data from a database behind authentication in Javascript?
Ultimately, I want to insert script into a spreadsheet to aggregate data from a database behind authentication.
So I have a nice little hand rolled Ajax call to my server pulling a list from the database and displaying it in a drop down list dependant on the user input. Aka Google suggest. I am wondering if the quickest way to do this is to call the database each time with Ajax and search the results with the input, or to write an xml from the database and search that. Then when the Database is updated rewrite the xml file.
Am I underestimating MYSQL again? Or not, and I feel it would be good practice to write the xml file because it will essentially mean a lot less database calls. But I don�t know how fast searching an xml file would be in comparison to a db call. The results from the database are say 500 entries anywhere between 10 - 100 characters each. I want to know A. The best way to do this B. Lets say the site will have pretty high traffic so I am looking for it to be as tweeked as possible. I can test but thought at the end of my week it was worth seeing what peoples advice is.
I am creating a job ticket object that will interact with a database. It has to update the database on the fly via AJAX. Within the job ticket object, I have instances of a Component Object. Within the Component Object, I have an instance of an Editor Object. One of the methods of the Editor object is a function to edit some text and when it's submitted, it will update the database. All of that is working fine. My problem is that I need to refresh the screen with the new contents of the database. I have a method in the Component Object that refreshes the screen, but how do I call it from within the Editor Object? I believe it has to be called there because the editor object has a handler for the form submission and the AJAX function. So I'll have to reference a callback function once the AJAX request is handled, but I don't know how to call it.
I know that sounds kind of convoluted, so hopefully, this very simplified code will paint a better picture of what I'm trying to do:
Code:
Now I want to call refreshScreen, but I don't know how:
Can i use single jquery and html to do some database manipulation i.e. database transaction.
View 1 Replies View RelatedI want to be able to grab words from a database with javascript. How do I do that?
View 2 Replies View RelatedI have been searching how to connect to a database and execute some queries, and then use the data that I get to populate some tables in a web page, all this using javascript.
I am confused because I have seen in some webpages that javascript is not designed to connect with databases, and also I have see other pages where they say that it is possible.
Does anyone know if it is possible to use javascript to connect to a database (informix), and execute some procedures or queries?
The user clicks on the delete icon, and gets a JavaScript client-side popup
to confirm that he wants to delete. I am passing this client-side function
a contactID.
Then, I want to send the result of this confirm (true|false) to a
server-side VBScript function, along with the contactID.
The VBScript function will then perform a delete in the database for the
specified contactID.
I have seen many examples about sending stuff back and forth between
JavaScript and VBScript, between server and client, but all the examples I
see are just popping up generic alerts and such. I need to execute some JS
on the client side, return a value, and send it to a VBScript function on
the server side.
how to convert below vbscript to javascript.
[Code]...
Is it possible to exchange data between Javascript and VBScript! In other words can they communicate!
View 4 Replies View RelatedI have some pages with this VBScript code, which obviously does not
work in Firefox. How can I convert this to Javascript in order for my
web page to work in Firefox ? It basically fills a drop down with a
list of dates that a user can select. Code:
From inside a javascript function i need to execute a vbscript sub routine.
You might be thinking why i can't do it in javascript. well i probably can but i am better at VBscript and it would be a lot easier.
I need some help converting this VBScript over to JavaScript so that the calculations will work properly in browsers other than IE.
You can take a look at Turn 2 Design Code: for a feel about what I'm trying to do, but basicly, I just need to calculate the cost of the selected items based on the selected quantity of that item.
The only thing I know about JavaScript is the small Pop-up scripts I've been able to litterally copy and paste to implement. So, please, dont just post code, post an explaination of whats going on and why so I can try to figure it out. Code:
Im using the onchange event for a dropdown list to change SQL statements based on the index of that dropdown chosen. For example I have a function like this for my onchange event of the drop down list.
<script type="text/javascript">
function listboxchange(index)
declare connection ...
[code]....
Not sure whether this should go in the JavaScript or VBScript/ASP section, but I'll try here anyway.
I have an ASP include file that contains both VBScript and JavaScript code. The VBScript processes some information and has an onChange event which calls a JavaScript function. Within this javascript function I want to access a recordset and retrieve a value using a variable from the javascript. Here's the code from the JavaScript section. Code:
Just wondering if anyone knew if there was a definite speed advantage to VBScipt as opposed to JavaScript?
View 7 Replies View RelatedI am wondering if there is any way to write a VBScript macro for IE,
just like the action that we can do in MS Excel (Tools -> Macro ->
Visual Basic Editor).
Also, I believe we can automate actions to IE pages using VBScript,
like when you right click a web page and choose "Export to Microsoft
Excel". But I have no idea how to get it.
Could you help me in this problem:
I want to launch an exe file(executable jar file) from a web page. I use jsp...and i cannot use vbScript...? could u tell me how should i do it?
I'm looking to return DATE ONLY for yesterday's date. No seconds,
milliseconds. Formatted either yyyy/mm/dd or mm/dd/yyyy. VB does it so
easily Date()-1 will return 03/27/2007 if today is 03/28/2007. Why so
many hoops for javascript? Any ideas?
I have the following function to get the total qty:
function calttl()
{
var ttlqty
ttlqty=0
for (i = 0; i <= document.qtymain.orderdetail.length-1; i++)
{
ttlqty = ttlqty + document.qtymain.qty.item(i).value
}
}
The problem I have is the document.qtymain.qty.item(i).value I get
look like a string, so the number I get for ttlqty is not add up the
number but concatenate.
How do I convert the value I get to a number in javascript?
Here is a compilation/creation/collection of recreated vbscript functions for use in JavaScript. Additions and criticism are of course welcome.
Zip file contains:
vbs.js
ReadMe.html
<Edit>Surprisingly there haven't been many downloads for this. Here's a quick overview of the contents:</Edit>
==================================================
==================================================
CreateObject(x)
Translates into: new ActiveXObject(x)
dateDiff(p_Interval, p_Date1, p_Date2,p_firstdayofweek, p_firstweekofyear)
Returns the number of intervals between two dates
datePart(p_Interval, p_Date,p_firstdayofweek, p_firstweekofyear)
Returns the specified part of a given date.
FormatCurrency(Expression, NumDigitsAfterDecimal,IncludeLeadingDigit,UseParensForNegativeNumbers, GroupDigits)
FormatDateTime(datetime, FormatType)
FormatNumber(Expression, NumDigitsAfterDecimal,IncludeLeadingDigit,UseParensForNegativeNumbers, GroupDigits)
FormatPercent(Expression, NumDigitsAfterDecimal,IncludeLeadingDigit,UseParensForNegativeNumbers, GroupDigits)
InStr(strSearch,charSearchFor)
Returns the first location a substring SearchForStr that was found in the string str
isDate(p_Expression)
Left(string, length)
Returns a specified number of characters from the left side of a string.
Len(str)
Returns the number of characters in a string.
LTrim(str)
Returns a copy of a string without leading spaces.
Mid(str,start,len)
Returns a specified number of characters from a string.
monthName(p_Date, p_abbreviate)
Now()
Returns the current date and time.
Right(string, length)
Returns a specified number of characters from the right side of a string
RTrim(string)
Returns a copy of a string without trailing spaces.
Trim(strInput)
Removes leading and trailing spaces
weekdayName(p_Date, p_abbreviate)
================================================
================================================
I'm getting the following error in IE on my Adobe Presenter file: Message: Type mismatch: 'SlideContent_DoFSCommand'
What could be causing the error? The presentation plays fine, just getting the error.