|
JavaScript - Javascript To Export Data From Sql To Word
Hi,
is it possible to create a script which exports data from a SQL server into MS Word? Similar TutorialsHi guys, here again with another question. I would parse a file, my js read fine an html file, but this one is an export from msword. I don't know if this is the problem. I can't change the file. here is how my js read: Code: <body>
<input type='button' value='Load' onclick="doLoad()" />
<script type='text/javascript'>
/* THIS IS THE FILE TO READ */
var fileToRead="test.html";
/* THIS FUNCTION IS TO READ THE HTML FILE */
function IO(U) {//LA MOD String Version. A tiny ajax library. by, DanDavis
var X = !window.XMLHttpRequest ? new ActiveXObject('Microsoft.XMLHTTP') : new XMLHttpRequest();
X.open('GET', U, false );
X.setRequestHeader('Content-Type', 'text/html')
X.send('');
return X.responseXML;}
function doLoad(){
/* HERE IS THE CALL TO READ THE FILE */
var orari=(IO(fileToRead));
var arrTR=orari.getElementsByTagName('tr');
var arrTD_3nd_line=arrTR[1].getElementsByTagName('td');
var arr_p_1c_3l=arrTD_3nd_line[0].getElementsByTagName('p');
alert(arr_p_1c_3l[0].nodeValue);
}
</script>
and here is a snip of the html i read: Code: <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<meta name="ProgId" content="Word.Document">
<meta name="Generator" content="Microsoft Word 10">
<meta name="Originator" content="Microsoft Word 10">
<link rel="File-List" href="orarioinvernale_file/filelist.xml">
<title>ORARI </title>
<!--[if gte mso 9]><xml>
<o:DocumentProperties>
<o:Author>Ufficio Stampa</o:Author>
<o:Template>Normal</o:Template>
<o:LastAuthor>Ufficio Stampa</o:LastAuthor>
<o:Revision>4</o:Revision>
<o:TotalTime>1</o:TotalTime>
<o:Created>2005-11-28T12:25:00Z</o:Created>
<o:LastSaved>2006-01-13T10:24:00Z</o:LastSaved>
<o:Pages>1</o:Pages>
<o:Words>762</o:Words>
<o:Characters>4344</o:Characters>
<o:Company>mycomp</o:Company>
<o:Lines>36</o:Lines>
<o:Paragraphs>10</o:Paragraphs>
<o:CharactersWithSpaces>5096</o:CharactersWithSpaces>
<o:Version>10.2625</o:Version>
</o:DocumentProperties>
</xml><![endif]--><!--[if gte mso 9]><xml>
<w:WordDocument>
<w:SpellingState>Clean</w:SpellingState>
<w:GrammarState>Clean</w:GrammarState>
<w:HyphenationZone>14</w:HyphenationZone>
<w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel>
</w:WordDocument>
</xml><![endif]-->
<style>
<!--
/* Font Definitions */
@font-face
{font-family:"Comic Sans MS";
panose-1:3 15 7 2 3 3 2 2 2 4;
mso-font-charset:0;
mso-generic-font-family:script;
mso-font-pitch:variable;
mso-font-signatu 647 0 0 0 159 0;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{mso-style-parent:"";
margin:0cm;
margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:12.0pt;
font-family:"Times New Roman";
mso-fareast-font-family:"Times New Roman";}
p
{mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
mso-pagination:widow-orphan;
font-size:12.0pt;
font-family:"Times New Roman";
mso-fareast-font-family:"Times New Roman";}
span.SpellE
{mso-style-name:"";
mso-spl-e:yes;}
span.GramE
{mso-style-name:"";
mso-gram-e:yes;}
@page Section1
{size:595.3pt 841.9pt;
margin:70.85pt 2.0cm 2.0cm 2.0cm;
mso-header-margin:35.4pt;
mso-footer-margin:35.4pt;
mso-paper-source:0;}
div.Section1
{page:Section1;}
-->
</style><!--[if gte mso 10]>
<style>
/* Style Definitions */
table.MsoNormalTable
{mso-style-name:"Tabella normale";
mso-tstyle-rowband-size:0;
mso-tstyle-colband-size:0;
mso-style-noshow:yes;
mso-style-parent:"";
mso-padding-alt:0cm 5.4pt 0cm 5.4pt;
mso-para-margin:0cm;
mso-para-margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:10.0pt;
font-family:"Times New Roman";}
</style>
<![endif]-->
<meta http-equiv="Content-Language" content="it">
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="4098"/>
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1"/>
</o:shapelayout></xml><![endif]-->
</head>
<body style="" bgcolor="#ccffff" lang="IT">
<div class="Section1">
<div style="text-align: center;">
</div>
<table class="MsoNormalTable" style="width: 100%;" border="1" cellpadding="0" height="1733" width="100%">
<tbody>
<tr style="height: 75.75pt;">
.... and so on.... the problem is that my error console (from firefox) when i click my read button (not when i load the page) gives me errors: Code: sintax error: source: <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> if i comment this it give me: Code: missing tag </meta>
source:
</head>
and if i put Code: </meta> another meta is required and so on. But i can't modify the source i read, so is there a way to read this file? Many thanks Backit Hi Guys, I have a javascript, which counts the specified words.. I want javascript to count some of the html tags and symbols when i enter a html code in the textarea.. - the below searchwords are not functioning properly. http://(space) http:/(space) etc... (no spaces are searching) - www. (.(dot) is not searching, also when i enter wwww(4 times) in the textarea it shows www. as count 1) - i can't enter the below symbols in searchwords array [ < ' ? I thank once again Bullant for helping me on the below script... But i am trying to fix my above issue and i couldn't.. :( Please help me out guys... Here is my Code... Code: <html>
<head>
<title>Word Count</title>
<script type = "text/javascript">
function searchForWords(){
document.getElementById('resultsContainer').innerHTML = '';
var txt = document.getElementById('txtMsg').value;
var strWords = document.getElementById('txtSearchWords').value;
var searchWordsTokens = strWords.split(' ');
var searchWords = ['href','LINK_ID','mailto','src="','src= ','src =','.jpg','.gif','.png','www','www.','http','http:// ','http:/ ','http: ','http ',' http',' "','@','amp;','TBD'];
for(i=0; i < searchWordsTokens.length; i++){
if(searchWordsTokens[i].length > 0){searchWords.push(searchWordsTokens[i]);} //remove spaces between words
}
var results = [],matches;
for(i=0; i < searchWords.length; i++){
var regex = new RegExp('\\b'+searchWords[i]+'\\b','gi');
matches = txt.match(regex);
results[searchWords[i]] = (matches)? matches.length : 0;
}
//output results
var str = '';
for(var i in results){
str += i+'--'+results[i]+'<br />';
}
document.getElementById('resultsContainer').innerHTML = str;
}
window.onload=function(){
document.getElementById('form_submit').onclick=searchForWords;
}
</script>
</head>
<body>
<table>
<tr><td align="center">
<form id="contact_form"><h4>Paste your HTML Code he </h4>
<p><label class="form_label" for='message'></label>
<textarea rows="20" cols="60" id="txtMsg"></textarea>
</p>
<div>
<input type="text" id="txtSearchWords"/>
</div>
<p><input id='form_submit' type="button" value="Check for Counts"></p>
<div><p><input id='form_submit' type="reset" value="Clear"></p></div>
<div id="resultsContainer"></div>
</form><br /></td>
</table>
</body>
</html>
Hi all i have a question... In my below code, I need to get rid of the radio option in my file. Count pure words and Count everything as words Also if i specify some content in the input box, it shows all the word count in the output box. I need only few mentioned words to be dispalyed instead For example, if i give input as below in the input box "Java allows you to play online games, chat with people around the world, calculate your mortgage interest, and in view images in 3D, just to name a few. It's also integral to the intranet applications and and other e-business solutions that are the foundation of corporate computing." I need only to display the count of Java , yours , in , and so that i output will be Java - 1 yours - 0 in - 2 and - 3 Can someone help me out in this please... Thanks a lot!!!:) Html Code ======================================================= Code: <html>
<head>
<title> Word Count </title>
<script language = "JavaScript">
function process1 (count) { // for words
m=new Array(10000);
m1=new Array(10000);
N=new Array (10000);
for (i=0;i<=1;i++) // which is chosen
{ if (count=1)
{ ch=i;
}
}
A=count.message.value; // original message
B="";
A=" " + A+" ";
A=A.toUpperCase(); // changes all alphas to Upper case
if (ch==0) // get rid of everything but apha's
{ condense1(count);
}
else
{ lesscondense(count);
}
for (i=1;i<=A.length;i++) // trims leading spaces and multiple spaces
{ if ((!(A.charAt(i)==" ")) || (!(A.charAt(i-1)==" ")))
{B=B + A.charAt(i);
}
}
//count.result1.value=B;
B=B+" "; // makes sure there is a space at end
k=0; str=" ";
for (i=0;i<=B.length;i++)
{ k1=B.indexOf(str,k);
if (k1==-1) //end of string B
{ Numwords=i-1;
break;
}
m[i+1]=B.substring(k,k1); // places all the words into an array m
k=k1+1;
}
//count.result1.value=B;
C="";
NN=0;
for (i=1;i<=Numwords; i++) // Numwords is total number of words
{ if (!(m[i]=="")) // only looks at m1 words that have not been processed before (not empty)
{ NN=NN+1; //unique word stored in m1 array
m1[NN]=m[i];
N[NN]=1; // initialize counter for word
for (j=i+1;j<=Numwords+1;j++) //counts and makes m1 elements with unique word empty.
{ if (m1[NN]==m[j])
{ N[NN]=N[NN]+1;
m[j]="";
}
}
}
}
C=C+"Unique:" + NN+" Total:" + Numwords+"\n";
C=C+"Freq.\tWord\n";
for (i=1;i<=NN;i++) // sets up C for showing
{ C=C + N[i]+ "\t" + m1[i] + "\n";
}
count.result1.value=C;
}
function condense1(count) { // allows only alpha's and spaces for choice 1
C="";
for (i=0;i<=A.length-1;i++)
{ k=A.charCodeAt(i);
if (((k>64) && (k<91)) || (k==32))
{ C=C+A.charAt(i);
}
else
{ C=C+" ";
}
}
A=C;
//count.result1.value=B;
}
function lesscondense(count) { // allows all characters from space on
C="";
for (i=0;i<=A.length-1;i++)
{ k=A.charCodeAt(i);
if (k>31)
{ C=C+A.charAt(i);
}
else
{ C=C+" ";
}
}
A=C;
}
//========================================
function letters1(count) { // counting characters upto unicode #255
mN=new Array(5000);
for (i=0;i<=1;i++) // which is chosen
{ if ( count.radio2[i].checked)
{ ch1=i;
}
}
A=count.message.value;
T=0;
for (i=0;i<=5000;i++) // initialize Array mN to 0
{ mN[i]=0;
}
for (i=0;i<=A.length-1;i++) // k is character and counted in mN[k]
{ k=A.charCodeAt(i);
mN[k]=mN[k]+1;
}
//count.result1.value=E;
D="";
D=D+"Freq.\tLetter\n"
if (ch1==0) // shows only alpha's and total number of letters T
{ for (i=65; i<91;i++)
{ if (!(mN[i]==0))
{ D=D + mN[i] + "\t"+ String.fromCharCode(i) + "\n";
T=T+mN[i];
}
}
for (i=97;i<=122;i++)
{ if (!(mN[i]==0))
{ D=D+mN[i]+"\t"+String.fromCharCode(i)+"\n";
T=T+mN[i];
}
}
}
else // shows all characters from space (32) to unicode 255
{ for (i=32; i<=255;i++)
{ if (!(mN[i]==0))
{ D=D + mN[i] + "\t"+ String.fromCharCode(i) + "\n";
T=T+mN[i];
}
}
}
count.result1.value=D;
count.total.value=T;
count.wordav.value=Math.round(T/Numwords*10000)/10000; // rounds off
}
//-- End
</script>
</head>
<body>
<form name ="count"><a name="Word_Counter"></a><font size="+1"><p> Count pure words<input type="radio" name="radio1" value="1" CHECKED>
Count everything as words <input type ="radio" name="radio1" value="0"><br> <br>
<table border="0" cellPadding="1" cellSpacing="1">
<tr>
<td><input id="button1" name="button1" onclick="process1(document.count)" style="height: 24px; width: 165px; font-weight: bold" type="button" value="COUNT WORDS"></td>
<strong><font face="Arial" color="#000080">Input your text into the box below:</font></strong><br><textarea cols=33 name=message rows=12 style="background-color: #ffffff; font-size: 10pt" wrap=PHYSICAL></textarea> <textarea cols=33 name=result1 rows=12 style="font-size: 10pt; font-family: Arial" wrap=PHYSICAL>WORD COUNT OUTPUT BOX</textarea>
<br><table border=0 cellPadding=1 cellSpacing=1>
<input type="reset" value="Reset" name="B1">
</body>
</html>
======================================================= This example works fine to match a users input. Code: if ((word[0]=="my") && (word[1]=="name") && (word[2]=="is") && (input.search(/(john|paul|zack)/)!=-1) && (num_of_words== 4))
{document.result.result.value = "Well, nice to meet you "+word[3]+".";
return true;}
However, can you do a search on what would be word[3] in the example above. Something like: word[3]=="(input.search(/(john|paul|zack)/)!=-1)" Thanks! Requirement: In one folder for ex: C:\NewFolder , I have so many word documents in this folder. Now what I have to do is, need to search for any string and it should search for that string in all documents inside that folder and should show output as the name of the docs where it found (same like windows search output) and i should be able to open those docs. I want to do this using Javascript. I'm new to javascripting. Kindly help me Sorry about the title, I didn't know what else to use to describe my problem. Basically, I'm generating a random word with a function; then I'm trying to pass this word down to another function. The problem is, when I pass the word, it changes each time (due to it being randomly generated originally). I'm only calling the function once (via button click), but I'm also calling the function in my code lower down to retrieve the returned variable; and the function seems to be running again and returning a new word from my array. Here's a snippet of my code: Code: function ranNum(){
var ranNum = Math.round(Math.random()*10);
var chosenWord = wordArray[ranNum];
return chosenWord;
}
function makeBoxes(x){
//remove children when new word is chosen
var hM = document.getElementById("hangMan");
while(hM.firstChild){
hM.removeChild(hM.firstChild);
}
var chosenWord = ranNum(x);
var wL = chosenWord.length;
//create box for length of letters in word
var i = 0;
for(i=0;i<wL;i++){
var cBoxes = document.createElement("div");
cBoxes.className = "letterBoxes";
cBoxes.innerHTML = chosenWord.charAt(i);
hangMan.appendChild(cBoxes);
}
return chosenWord;
}
function checkLetter(y){
var chosenWord = makeBoxes(y);
alert(chosenWord);
}
So I generate a word with one button; now I need to be able to work with said word in my checkLetter() function. The word changes however. Any help would be greatly received. I found a nice script online that will count words. Problem is, I need it to also count each DIGIT (0-9) as a seperate word, whether the numbers are seperated by a space or not. I've searched this forum to no avail. Can anyone help me or show me how to do this, here is the original script: Code: <!-- TWO STEPS TO INSTALL WORD COUNT:
1. Copy the coding into the HEAD of your HTML document
2. Add the last code into the BODY of your HTML document -->
<!-- STEP ONE: Paste this code into the HEAD of your HTML document -->
<HEAD>
<SCRIPT LANGUAGE="JavaScript">
<!-- Original: Shawn Seley -->
<!-- This script and many more are available free online at -->
<!-- The JavaScript Source!! http://javascript.internet.com -->
<!-- Begin
function CountWords (this_field, show_word_count, show_char_count) {
if (show_word_count == null) {
show_word_count = true;
}
if (show_char_count == null) {
show_char_count = false;
}
var char_count = this_field.value.length;
var fullStr = this_field.value + " ";
var initial_whitespace_rExp = /^[^A-Za-z0-9]+/gi;
var left_trimmedStr = fullStr.replace(initial_whitespace_rExp, "");
var non_alphanumerics_rExp = rExp = /[^A-Za-z0-9]+/gi;
var cleanedStr = left_trimmedStr.replace(non_alphanumerics_rExp, " ");
var splitString = cleanedStr.split(" ");
var word_count = splitString.length -1;
if (fullStr.length <2) {
word_count = 0;
}
if (word_count == 1) {
wordOrWords = " word";
}
else {
wordOrWords = " words";
}
if (char_count == 1) {
charOrChars = " character";
} else {
charOrChars = " characters";
}
if (show_word_count & show_char_count) {
alert ("Word Count:\n" + " " + word_count + wordOrWords + "\n" + " " + char_count + charOrChars);
}
else {
if (show_word_count) {
alert ("Word Count: " + word_count + wordOrWords);
}
else {
if (show_char_count) {
alert ("Character Count: " + char_count + charOrChars);
}
}
}
return word_count;
}
// End -->
</script>
</HEAD>
<!-- STEP TWO: Copy this code into the BODY of your HTML document -->
<BODY>
<form>
<textarea cols=40 rows=5 name=x>
</textarea>
<br>
<input type=button value="Count Words" OnClick ="CountWords(this.form.x, true, true);">
</form>
<p><center>
<font face="arial, helvetica" size"-2">Free JavaScripts provided<br>
by <a href="http://javascriptsource.com">The JavaScript Source</a></font>
</center><p>
<!-- Script Size: 2.04 KB -->
Hi, I have a code written in Javascript to export to Excel. It is not working for my PC as open office is installed in it. If I check with ms-office the code works, can anyone please suggest me what shld i do for it. Below is the code in javascript. function exportToExcel() { var oExcel = new ActiveXObject("Excel.Application"); var oBook = oExcel.Workbooks.Add; var oSheet = oBook.Worksheets(1); for (var y=0;y<detailsTable.rows.length;y++) // detailsTable is the table where the content to be exported is { for (var x=0;x<detailsTable.rows(y).cells.length;x++) { oSheet.Cells(y+1,x+1) =detailsTable.rows(y).cells(x).innerText; } } Please suggest me what code i should keep or what I should change. -- Thanks in Advance.. Hi Chaps, I have some Javascript code, that sucessfully exports Project data from an HTML table to an Excel SpreadSheet: Code: function ExportToExcel() {
var xlApp = new ActiveXObject("Excel.Application");
// Silent-mode:
xlApp.Visible = true;
xlApp.DisplayAlerts = false;
var xlBook = xlApp.Workbooks.Add();
xlBook.worksheets("Sheet1").activate;
var XlSheet = xlBook.activeSheet;
XlSheet.Name="Project Details";
// Store the sheet header names in an array
var rows = tbldisplay.getElementsByTagName("tr");
var columns = tbldisplay.getElementsByTagName("th");
var data = tbldisplay.getElementsByTagName("td");
//run over the dynamic result table and pull out the values and insert into corresponding Excel cells
var d = 0;
for (r=4;r<rows.length+3;r++) { // start at row 2 as we've added in headers - so also add in another row!
for (c=1;c<columns.length+1;c++) {
XlSheet.cells(r,c).value = data[d].innerText;
d = d + 1;
}
}
//autofit the columns
XlSheet.columns.autofit;
// Make visible:
xlApp.visible = true;
xlApp.DisplayAlerts = true;
CollectGarbage();
//xlApp.Quit();
}
As you can see, a new workbook is created and the data is exported to Excel ("Sheet1"). What I want to do is as soon as this export is complete, redirect to a seperate page, where the Jobs (linked to the Project) details are exported to Excel ("Sheet2"), without creating a new workbook. Is this do-able? Hello, I used a standard orderform which I expanded. With this form people can order some products. But when I submit the form with data from a javascript the mail is empty. Can anyone help? I am just a beginner.... You can try the form here Thanks in advance! Hein. i have know that JavaScript the data types are either:Primitive (number", "string", "boolean", "undefined",null), or Non-primitive (objects). but why the return values of using typeof can be "function"? i feel this collide with the above. I have this idea that I want to do basically a "state capture" of a web page through javascript. Basically, a user will click a button, and the script will run, capturing all objects and their styles in a way that can be recreated later without referencing external CSS files and images. The script could export HTML or JS, but obviously all images would have to be data urls and all styles would have to be inline/hard coded. Does anyone know of a tool that do this or have any advice on where I would start? I'm thinking it would be very useful for a bug report submission on an application I'm working on. Sure, the user can upload a screenshot, but I'm trying to save them the step (and basically have a screenshot on every bug report). JS cannot do an actual image capture, so I think a full dom export would be just as good. Any ideas would be fantastic. Hi guys I d like to know that is it possible to submit data to the server or to an email from the client using JAVAScript? I know that javascript is clientside,but if you work with Facebook, when you chat, just view its source, u ll see that is using Javascript? I d like to know,how is it possible? Please help ... bit urgent I am creating a small automated system where front-end is html query form and back-end database is MS excel. both at local PC only & in a single folder. problem is like a survey form. continuous data entry, error correction, read/wite all these are included. I created a program upto first entry; but the second, third, ... entries and it is continuous. pl help me regards K.Kaniraj I wants to access server web page which data is continuously growing(streaming data), I want to buffered some of that data write it in responseText then again get next buffered data write it and so on (in AJAX). Is it possible? if yes how to do that? I have some data on the client side in javascript arrays that I display to user in a html table on the webpage. I want to give an option to the user to save the data in excel. I thought of a solution that involves: 1. Create an http request and post the data as json 2. On server using jsp convert the json data to html table 3. Set the response headers to open the response in excel This solution works, but does not look optimal. Why to send a http request to server when all the data is there on client side. I tried creating a new document on the client side and open that in a new window. That does not open the document in excel as the response header is not set. Any suggestions on how to achieve this. I want to avoid http request to server. Thanks, Pawinder HTML: Code: <script src="./include/js/drinkValidation.js" type="text/javascript"></script> <form name="add-drinks" action="include/add-drink.php" method="POST" onSubmit="return addDrinkFormValidation(this);" enctype="multipart/form-data" > <span id="colour" class='modify_form'> <label for='drinkColour'>Spirit Colour:</label> <br /> <select name='drinkColour' tabindex=1> <option value='' >None</option> <option value='R' >R</option> <option value='G' >G</option> <option value='Y' >Y</option> </select> </span> <div class='modify_form'> <label for='drinkType'>Type:</label> <br /> <select name='drinkType' tabindex=1 onChange="HideObjects(this.value)"> <option value="">Select a Drink type:</option> <option value='Cask' >Cask Ales</option> <option value='Guest' >Guest Ale</option> <option value='Lager' >Lager</option> <option value='Bottled Beers' >Bottled Beer</option> <option value='Wines' >Wine</option> <option value='Ciders' >Cider</option> <option value='Softs' >Soft</option> <option value='Spirits' >Spirit</option> </select> </div> <div id="drinkABV" class='modify_form'> <label for='drinkABV'>ABV:</label> <br /> <input name='drinkABV' size='2' tabindex=4 maxlength="4" placeholder="ie: 4.2"/> <label for='drinkABV'>%</label> </div> <div id="name"class='modify_form'> <label for='name'>Name:</label> <br /> <input name='name' size='25' tabindex=3 placeholder="Drink name"/> </div> <div id="drinkInfo" class='modify_form'> <label for='drinkInfo'>Description:</label> <br /> <textarea name='drinkInfo' rows='5' cols='30' maxlength='255' tabindex=5 placeholder="Max 255 characters"></textarea> </div> <div id="pint" class='modify_form'> <label for='drinkPintPrice'>Pint (£):</label> <br /> <input name='drinkPintPrice' size='10' tabindex=8 /> </div> <div id="halfpint" class='modify_form'> <label for='drinkHalfPrice'>Half Pint (£):</label> <br /> <input name='drinkHalfPrice' size='10' tabindex=7 /> </div> <div id="drinkSpecialPrice" class='modify_form'> <label for='drinkSpecialPrice'>Offer Price (£):</label> <br /> <input name='drinkSpecialPrice' size='10'tabindex=6 /> </div> <div id="drinkbottlePrice" class='modify_form'> <label for='drinkbottlePrice'>Bottle/Spirit Price (£):</label> <br /> <input name='drinkbottlePrice' size='10'tabindex=6 /> </div> <br /> <br /> <input type="file" name="cons_image" /> <br /> <br /> <div id='submit'> <input type='submit' value='Add New Drink' /> </div> <br /> <p><b>Please add the information you wish to add then click Add New Drink</b></p> </form> Javascript containing validation Code: var ck_abv = /[0-9]{1,2}\\.[0-9]{1}$/;
var ck_price = /[0-9]{1,2}\\.[0-9]{2}$/;
var ck_name = /^[A-Za-z0-9 ]{3,20}$/;
var ck_info = /^[A-Za-z0-9 ]{3,255}$/;
alert ("Im in the file");
function addDrinkFormValidation(form){
var type = form.drinkType.value;
var abv = form.drinkABV.value;
var name = form.name.value;
var info = form.drinkInfo.value;
var pint = form.pint.value;
var halfpint = form.halfpint.value;
var bottle = form.drinkbottleprice.value;
var offer = form.drinkSpecialprice.value;
var errors = [];
alert (form);
alert (type);
alert (abv);
alert (info);
alert (pint);
alert (halfpint);
alert ("Anything showing");
if(type==0){
errors[errors.length] = "Please select a drink type.";
}
if(!ck_name.test(name) || (name == "")){
errors[errors.length] = "Please enter a drink name.";
}
if(!ck_info.test(info) || (info == "")){
errors[errors.length] = "Please enter a drink description.";
}
if(!ck_abv.test(abv)){
errors[errors.length] = "Illegal character in ABV";
}
if(!ck_price.test(pint)){
errors[errors.length] = "Illegal character in pint";
}
if(!ck_price.test(halfpint)){
errors[errors.length] = "Illegal character in halfpint";
}
if(!ck_price.test(bottle)){
errors[errors.length] = "Illegal character in Bottle/Spirit Price";
}
if(!ck_price.test(offer)){
errors[errors.length] = "Illegal character in Offer price";
}
if (errors.length > 0) {
reportErrors(errors);
return false;
}
return false;
}
function reportErrors(errors){
var msg = "Please Enter Valid Data...\n";
for (var i = 0; i<errors.length; i++) {
var numError = i + 1;
msg += "\n" + numError + ". " + errors[i];
}
alert(msg);
}
For some reason i dont know why the javascript isnt reading the function even tho they are correctly named, the file is being read as the 1st test alert comes up. the 2nd one inside the function doesnt know. can anyone point in the right place or show me where i am going wrong. as you can see i have put both my entire form and and the java file up. so you can easily see what goes on #on a note i have multiple forms in a tab system if that has anything to do with it although i shouldnt see why it should. #oh and did i get my regex correct for ck_price e.g "9.99 or 10.99" and ck_abv eg "4.2 or 10.2 or 34" #im also using wampserver 2.1 with win7 and chrome if it's needed thanks ste |
|||||||