Resolved Accessing Local Data Using JS?
Jul 19, 2011
I am working on a project using HTML and javascript to allow the user to choose a vehicle from a drop down menu, then load a new page showing some information about this vehicle. The information is stored in an Excel file. I posted regarding this issue a while back and got an excellent response from Old Pedant about using ActiveX - which has thus far worked perfectly. My initial condition was that I would only be using IE7+. However, my next idea was to be able to use it on an IPad (which I unfortunately do not own yet, making any kind of testing difficult) which I am fairly certain ActiveX won't work on. So, I was looking for any other method which would be similar.
Important note: this will not use the internet at all, all of these files will be available locally. There is a lot of material on running queries to servers, but I didn't think that would really apply here. It seems pretty clear that JS has difficulty accessing files client side (which I understand why completely), but I was hoping to find something that worked for the gray zone I'm currently working in since I'm not using servers at all.
I know that this is not really the intended use of HTML/JS, but I was hoping that by writing it as an HTML file, it'd be accessible to anyone with a browser. Some of my target computers have odd limitations (such as not being to download .exe files).The code I based my original off of is shown below:
<script type="text/javascript">
var conn = new ActiveXObject("ADODB.Connection")
conn.Open ( 'Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:fullpath oMyExcel.xls;Extended Properties="Excel 8.0;HDR=Yes;IMEX=1";)';
var sql = "SELECT * FROM [nameOfSheet$]";
var rs = conn.execute( sql )
[Code]...
View 1 Replies
ADVERTISEMENT
May 3, 2011
I have an html file I've built with embedded Javascript (using ActiveX) that successfully reads a file on my local hard drive when I run the html file through my web browser (IE) locally. However, when I copy the html page up to a webserver and access it through the internet, it doesn't appear to be reading the local file. I'm assuming this can't be done because of security reasons? Am I correct in that? Is there any way using Javascript/ ActiveX that you can get a webpage on the internet to access a file on the visitor's local drive?
View 9 Replies
View Related
Oct 26, 2011
I have just started to learn about JQuery and wanted to learn how to retrieve data from an API.
I used the Flickr example provided here [url] and just changed the relevant code to point to the 500px api.
<body>
If I launch the following URL I do get the results properly [url]
Here's a sample of what the result looks like:-
I don't get any results when I run my code page. What am I doing wrong?
View 15 Replies
View Related
Jul 23, 2005
I've been using some code to verify form data quite happily, but i've
recently changed the way my form is structured, and I can't get it to work
now.
Originally :
The form is called "form1", and I have selects called "PORTA", "PORTB" ...
etc...
I then had javascript that accessed these selects as below, and it worked
fine.
ind = document.form1.PORTD.selectedIndex;
val = document.form1.PORTD.options[ind].value;
dev = document.form1.PORTD.options[ind].text;
My form is now autogenerated, and form data is stored to file, so I now use
an associative array for thte form elements (so that I can loop through them
easily), The form elements names are now :
McuCfg[PORTA], McuCfg{PORTB} and so on
Now, I modified the javascript so that it now uses the McuCfg[] associative
array :
ind = document.form1.McuCfg[PORTD].selectedIndex;
val = document.form1.McuCfg[PORTD].options[ind].value;
dev = document.form1.McuCfg[PORTD].options[ind].text;
When the script runs, I get the error
"document.form1.McuCfg.PORTD is null or not an object"
I have used the same notation that i know works for the "options" array
although that's not an associative array.
View 6 Replies
View Related
Jun 7, 2010
it seems to be a problem if I need to access data() of the elements from another window, like for example $(anyElement,window.opener.document).data() which returns null when in fact there is some data actually stored. I heard that data is stored in the $.cache, which is window-related, so that's understandable, but how can I work around that?
Certain plugins that use $.data no longer work correctly because of that. E.g., I can't use linkselectmethods on linkselects located in the window.opener.document. Again, is there any workaround?
View 1 Replies
View Related
Oct 8, 2010
I feel like I've been server-side programming so long that I completely forget how client-side works. I have a super simple form:
Code:
<form action="page2.html" method="post/get">
First name: <input type="text" name="firstname" /><br />
Last name: <input type="text" name="lastname" />
<input type="submit" value="Submit" />
</form>
Is there a way to use Javascript on "page2.html" to access the contents of firstname and lastname and display them?
View 1 Replies
View Related
Feb 3, 2011
what I am trying to accomplish is done through javascript, but I think that it is.
I would like to access server-side data without refreshing the entire page. Is this done through layers somehow?
View 2 Replies
View Related
Jul 23, 2005
I'm, having some problems with this function.
function displayElements()
{
for (i=0;i<document.forms[0].elements.length; ++i)
{
document.writeln(document.forms[0].elements[i].value);
}
}
I'm trying to loop through the only form (form[0]?) on my webpage and
display all their values. For some reason I'm only being shown the first
value?
View 7 Replies
View Related
Oct 8, 2010
I have 3 Jquery tabs on the form. Each tab contain same HTML Tables, I want to access the data in a Cell of a table in an active tab on the button click
in normal Case I use
var x=document.getElementById("searchResultTable").rows[10].cells;
referenceNo=x[2].innerHTML;// get the value in the Cell
alert( "x[2].innerHTML);
if i use this Code i get only the First Table data .All the Tabs Contains Same Table with Same Id and Name
View 6 Replies
View Related
Nov 2, 2010
var attrIndexes = [];
$.get(queryString, function(data) {
attrIndexes = data.split(",");
});
after running this code the original variable is empty so something is wrong
View 3 Replies
View Related
Oct 16, 2009
Lets say I wanted store a long string of text into a local storage member on a browser using javascript.
window.localStorage.setItem("key",longStringText);
Now lets assume that the text itself contains characters outside of the normal ISO-8859-1 character set (like asian or russian characters). Would the individual char values be stored as one byte or two bytes?
"hello" -> 5 * 1 bytes = 5 (normal 8859 character sets)
"hello" -> 5 * 2 bytes = 10 (unicode or an extended character set size).
Is ISO-8859-1 still stored like ASCII once was as 8 bits? Or is it 16? If I was to use a 2 byte character set then would that cut the size of my allocated local storage space by half?
View 3 Replies
View Related
Jul 23, 2005
I have a frame in which there are 2 IFrames., both being loaded from
the same domain. One IFrame is loaded from http://test1.xyz.com and the
other IFrame is loaded from https://test1.xyz.com/test
I am getting an error while accessing data in the HTTP IFRAME from the
HTTPS IFRAME.
Is it possible at all to access the data in the other IFrame, when the
protocol is different?
View 1 Replies
View Related
Apr 1, 2010
When retrieving JSON data I'm able to access individual elements using the $.each() function and iterate over them. However, how would I access just one element by its location and not by name? (i.e. data(0) not data.ID).
View 3 Replies
View Related
Mar 18, 2010
I've got the following code:
[Code]...
I was just wondering how will I be able to access the content of the data variable in script.template.php?
The other problem is that when I use the $.getJSON method (instead of just $.get), the script doesn't appear to get called.
View 1 Replies
View Related
Nov 30, 2010
So I'm currently working on a ASP.NET Webforms site and I've run in to a small problem. On my .cs file I have the following Webmethod
[WebMethod]
public static string IsJobEditable(int jobid){
try{
string isEditable = "false";
JobsBLL jbl = new JobsBLL();
int jobStatusId = jbl.GetJobStatusId(jobid);
//If the jobs is either waiting or being edited it is
okay to edit it
if(jobStatusId ==
Convert.ToInt32(ConstantsUtil.JobStatus.Waiting) || jobStatusId ==
Convert.ToInt32(ConstantsUtil.JobStatus.Edit)){
isEditable = "true";
}return isEditable;
}catch (Exception ex){
throw ex;
}}
This function in this case will ALWAYS return TRUE as a string. On Aspx page I have the following
$(function () {
$.ajax({
type: "POST",
url: "Coordination.aspx/IsJobEditable",
data: "{jobid:" + jobid + "}",
contentType: "application/json; charset=utf-8",
dataType: "text",
success: function (result) {
alert(result);
//This is written out in the alert {"d":"true"}
I want this in a variable as a string so I can do a check on it before I do some other actions. The format is not a String so I cannot split on it to retrieve the "true" part.
},
error: function (err, result) { alert(err); }
});});
As you can see in the comments the value I get back in the Callback method is in to me a weird format. The type is unknown and I need this value to be able to proceed with my entire method surrounding the small portion of the Javascript. Where to access the result variable / data as a var or anything else that will let me put it into a var (as a string).
View 1 Replies
View Related
Jul 23, 2005
I am working on a PHP-script and need javascript to set the value of a
hidden field in a form. This field happens to be an entry in an array
data[3] according to my example. How can I do this?
Below is listet two PHP-pages: one that doesn't work (to my dismay), and
another that does work, but do not use an array entry in the hidden field. Code:
View 1 Replies
View Related
Aug 8, 2010
I am looking for a custom pop up box, but there is only 3 kinds (Alert, Confirm, Prompt). Neither of those will work.
View 13 Replies
View Related
Jun 19, 2009
why does this work under FF and only ONCE in IE but the problem remains the same as the firefox only code crashed IE's javascript.so it works only once still.SOLUTION -> changed event from onchange to onclick for my checkbox calling that function !
View 4 Replies
View Related
Dec 16, 2009
I am trying to make an order form I am working on accessible for users who have javascript turned off in their browser, and to do this I would like to hide a div if JS is disabled.
Searching the Web has led me to think that styling the div to not display is the way forward and then using JS to display it. It is the JS bit I am struggling with! The div in question is a set of radio buttons to allow a purchaser to choose how many gift memberships they want to buy:
<div id="giftmember-buttons" style="display:none";>
<h2 class="threepeaksform">How many gift memberships do you wish to purchase?</h2>
<fieldset class="threepeaksform">
<legend>Please select the number of people you are buying a gift membership for using the buttons below.</legend>
<div class="generalcontactform-group">
[Code]...
View 3 Replies
View Related
Mar 10, 2010
I have youtube link saved as a variable with value:[URL]... And I need to get a part of this link which I could use later:
The part would be oOzuBOefL8I It would be great to do it with javascript... Because I have url generated like this one:
httpObject.open("GET", "../talpinimas.php?id=reklama&paveikslelis="
+document.getElementById('paveikslelis').value+"&pavadinimas="
+document.getElementById('pavadinimas').value+"&url1="
+document.getElementById('url1').value+"&url1name="
+document.getElementById('url1name').value+"&komentaras="
[Code]...
View 9 Replies
View Related
Jun 22, 2010
What I'm trying to do just doesn't seem like it should be that difficult but I'm sure struggling with lacking skills I should say. I'm trying to automatically scroll a div up and down. For say if div.scrollTop = 0 then scroll to the bottom once it reaches the bottom scroll back up and so forth not stopping in a loop with say a timeout of 10.. Just need help putting it all together.
I've figured some stuff out:
I can tell if I'm at the bottom of the scrollable area with:
(document.getElementById(id).clientHeight + document.getElementById(id).scrollTop) - document.getElementById(id).scrollHeight
[Code]...
View 3 Replies
View Related
Sep 13, 2011
I'm trying to create a test using Javascript. Actually, I did this in PHP, but we need to put it a server that does nor run it, I think I can convert it to Javascript. I hope it'll be work as in PHP somehow. Test will be composed of 15 questions and each question has either "Yes" or "No" as answer. And, I use radio buttons here for answers. By the way, there will be more than one radio groups. Now, I want to check the value of clicked radio button in each group and use an if-statement to determine if it's correct. And, if it's correct, I want to increment a variable by 1. Finally, by the resulted variable incremented for each question in the test, I want to use another if-statement to show specific result message for and interval of that variable.
[Code]...
View 4 Replies
View Related
Mar 11, 2011
I'm new to javascript, and i'm having a problem. I want a button, which functions as a toggle, but also as a mouseover. When you click, under the button, a div opens with text. And when you mouse over, a shadow appears behind the button.I have two pieces of javascript, but i want both in my button. Can anybody help me?
[URL]
View 1 Replies
View Related
Feb 28, 2009
I'm trying to add watch() to IE, and have more or less working code:[code]That works until I try to use setInterval with the code in red color. I never really tried OOP or prototyping in JS, so my whole approach to the problem might be wrong, but anyway, I think that if I execute that code in red every 100ms [for example], I'll be able to catch changes to properties on which the method is registered. Well, either my idea is wrong, or the execution.Some parts are commented out and method name is changed so that I could work in peace in FF.
View 3 Replies
View Related
Jun 5, 2009
I'm looking for a lightbox that allows me to have 3 lines of captions. Line one would be the art title, line two would be art dimensions, and line three would be media used. Would someone point me in the right direction? I have a lightbox that supports multiple lines, but doesn't allow for line breaks in the caption.
View 6 Replies
View Related
Aug 9, 2009
New to JS, and not too good at it. Trying to take some prewritten code and add script that displays some random text. Having trouble with assignment. Instructions are to replace a section of the file I am given with a script element. In the script element I am suppose to declare a variable named tipNum equal to a random integer between 1 and 10 returned by the randInt() function (which I made and have shown below). Then I am suppose to use a series of document.write() methods to write the following HTML code into the page:
<h1>Random Tip<br />title</h1>
<p>tip</p>
(Where "title" is the title of the random text as generated by the tipTitle() function from a external file, and which I did not make; and "tip" is the text of the random tip as genereated by the tipText() function, which is also from the external file, and not made by me) My code for the randInt() function is
function randInt(lower, upper) {
var size = ++(upper - lower);
var randValue = Math.floor(lower + size*Math.random());
}
The script I made to display the HTML code is
[Code]...
I am getting nothing on my page where the random text should be.
View 7 Replies
View Related