Jump to content


  • Posts

  • Joined

  • Last visited

Posts posted by jojay

  1. I am new to uploading videos to the website. Can someone suggest a simple way to upload video to the website and update? What software is needed in order to upload or encoding? Please help. Thanks.

  2. I have a problem with matching columns in excel spreadsheet. I have the following:Column A - /jj/JOJAY Column B - 1234Column C - AndyColumn A - dd/AndyColumn B - 3456Column C - JOJAYI want to match the column A with column C and do a sort to fetch the correct username. I tried doing with VLOOKUP and it isn't giving me what I want. How will I do that? Can someone please help? Thanks.

  3. Hi,  Iam an XML newbie here. I have a XML file & can display it contents using XSL file. Now what i want to do is show all elements &  2 of the elements in textboxes & allow the user to edit these and on submiting this form, update those elements in XML file,& again display all these elements.   When dispalying the elements in textboxes how do i name them(textboxes),so that on submitting the form i can update the XML file. Pls clarify.Thanks in Advance.

    Read the article below, it tells how to update XML,XSL files using asp, if you are familiar with asp coding.http://xmlfiles.com/articles/michael/editingxml/default.aspHope this helps.
  4. I am brand new to scripting and this is my first page - I've been working on this for most of the evening and thought I'd ask for help.I get the following error message: ADODB.Recordset error '800a0e79' Operation is not allowed when the object is open. /Members/setup/add_department.asp, line 143Here is my HTML contents:<html><script language="VBscript"></script>  <head>      <title>Sign Up</title>  </head>  <!--#include file = "../../global.inc"-->  <body topmargin="0" leftmargin="0">      <table border="0" cellpadding="0" cellspacing="0" width="100%">        <tr>            <td id="headerBox"><!-- Header Graphics -->                  <!--webbot bot="Include" U-Include="../../Menus/MemberHeader.htm"-->              <a name="top"></a>              <table border="0" cellpadding="0" cellspacing="0" width="800">                  <tr>                    <td id="headerBox" width="799">                        <!-- Header Graphics -->                        <table border="0" cellpadding="0" cellspacing="0" width="760">                        </table>      <hr color="#000080">      <p><img border="0" src="../../images/newmem2.gif"><font face="Arial" size="2">Outreach 28 is designed on departments      completing events.  Once your departments are set-up you will complete the      event associated      with each department.  Then you will map on which day each event is to be      completed.  Listed at the bottom of the page are default departments and      default events you can edit or delete. </font></p>      </td>  </tr></table><table width="745"><form name="frm" method="post" action="">  <tr>    <td colSpan="6" width="1526">      <h3 align="center"><font color="#000080" face="Arial">Department      Information</font></h3>    </td>  </tr>  <tr>    <td width="4"><font face="Arial"> </font></td>    <td width="127" align="right"><font face="Arial" size="2">Department Name:</font></td>    <td width="220"><font face="Arial">    <input maxLength="50" name="Dept_Name" size="30"></font></td>    <td width="1"></td>    <td width="178" align="right"><font face="Arial" size="2">Department      Description:</font></td>    <td width="169"><font face="Arial">    <input maxLength="50" name="Dept_Desc" size="30"></font></td>  </tr>  <tr>    <td width="4"><font face="Arial"> </font></td>    <td width="127" align="right"><font face="Arial" size="2">Coordinator's  Name:</font></td>    <td width="220"><select name="Dept_Coord" size="1">    <%      Response.Buffer=True      select_sql2="SELECT Member_FName, Member_LName FROM Tbl_Member WHERE Church_ID = '"&session("Church_ID")&"'"            conn.open connect_string      Rs.open select_sql2, connect_string conn.Execute(select_sql2)%><option>Please select a member</option>    <% While Not rs.EOF %><option><%=Response.Write(Rs("Member_Fname") & " " & Rs("Member_LName")) %></option>      <% rs.movenext %>      <% Wend %><% conn.close %>      </select></td>    <td width="1"></td>    <td width="537" colspan="2"><font face="Arial" size="2" color="#008000"><a href="http://">Add      Events for this Department</a></font></td>  </tr>  <tr>    <td align="right" colSpan="6" width="1526">    <p align="center"> </td>  </tr>  <tr>    <td align="right" colSpan="6" width="1526">    <p align="left">      <input type="submit" name="btnSave" value="Save Department Information">      <input type="submit" name="btnBack" value="<< Back">      <input type="submit" name="btnNext" value="Next >>" onclick="NextClicked();" tabindex="12">      <input type="button" name="btnCancel" value="Cancel">            <%      Response.Buffer=True      select_sql="SELECT Dept_Name, Dept_Desc, Dept_Coord FROM Tbl_Dept WHERE Church_ID = '"&session("Church_ID")&"'"            conn.open connect_string      Rs.open select_sql, connect_string conn.Execute(select_sql) 'conn.close 'set conn=nothing %><% Dept_Name=Request.Form("Dept_Name")Dept_Desc=Request.Form("Dept_Desc")Dept_Coord=Request.Form("Dept_Coord")status=Request.Form("Status")submit_button=Request.Form("btnSave")next_button=Request.Form("btnNext")back_button=Request.Form("btnBack")dim insert_sqlinsert_sql="INSERT INTO tbl_Dept (Dept_Name, Dept_Desc, Dept_Coord, Church_ID) VALUES ('"&Dept_Name&"', '"&Dept_Desc&"', '"&Dept_Coord&"', '"&session("Church_ID")&"')"Response.write(submit_button)if submit_button = "Save Department Information" then conn.open connect_string Response.write(insert_sql) conn.Execute(insert_sql) 'conn.close set conn=nothing response.redirect("../setup/add_department.asp")         end ifif next_button = "Next >>" thenResponse.Redirect("../setup/newworker.asp")end ifif back_button = "<< Back" thenResponse.Redirect("../setup/newmember.asp")end if%><!----------- This page goes to newdirector next-------------- ------->      <!-- Include File = "../processfiles/printvariables.asp"-->      <!----------- END PAGE CONTENTS--------------------->      </td>  </tr></table><p><u><font face="Arial" color="#000080"><b>Current Departments</b></font></u></p><table border="0" width="95%">  <tr>    <td width="4%" bgcolor="#000080"> </td>    <td width="3%" bgcolor="#000080"> </td>    <td width="15%" bgcolor="#000080" align="center"><font color="#FFFFFF" face="Arial" size="1"><b>Department      Name</b></font></td>    <td width="11%" bgcolor="#000080" align="center"><font color="#FFFFFF" face="Arial" size="1"><b>Coordinator's      Name</b></font></td>    <td width="26%" bgcolor="#000080" align="center"><b>    <font face="Arial" size="1" color="#FFFFFF">Department Description</font></b></td>  </tr>    <% While Not rs.EOF %>  <tr>    <td width="4%" bgcolor="#FFFFFF"><font color="#008000" size="2">Edit</font></td>    <td width="3%" bgcolor="#FFFFFF"><font color="#008000" size="2">Delete</font></td>    <td width="15%" bgcolor="#FFFFFF" align="center"><font color="#08399C" size="2"><%=Response.Write(Rs("Dept_Name")) %></font></td>    <td width="11%" bgcolor="#FFFFFF" align="center"><font color="#08399C" size="2"><%=Response.Write(Rs("Dept_Coord")) %></font></td>    <td width="26%" bgcolor="#FFFFFF" align="center"><font size="2" color="#08399C"><%=Response.Write(Rs("Dept_Desc")) %></font></td>  </tr>      <% rs.movenext %>      <% Wend %></table></form><br><!--webbot bot="Include" U-Include="../../Menus/setup_bottom_menu_2.htm" TAG="BODY" --></body></html>

    I am not sure but it can be becoz you have commented out the conn.close and conn = nothing. That error usually happens when the connection is open. It is better if you just post the code where the line says error, then it is easier to identify.
  5. In above code, lastName is my database field.Cheers,PRANAV

    What does the above quote mean? Do you have only lastname as database field? where does the username and password come from? In your error message, the error will point out to your filename and line number, where does it points to?
  6. Hi again..Is it possible at all to make anything out of this server_stats.xml??

    If you are trying Data Island using javascript just like the previous one, then it should be something like the one below. I have worked out a sample code:xml file:
    <?xml version="1.0" encoding="ISO-8859-1" ?><mani_stats>        <User>     	 <steam_id>{	"version" "V1.2BetaN RC1"	"1"	{	"na" "(SVB)Tbonekiller"	"st" "STEAM_0:1:1163382"	"ip1" "10"	"ip2" "0"	"ip3" "0"	"ip4" "2"	"lc" "1148572704"	"rwhiteness.xsl	</steam_id>		<name>killer"	"st" "STEAM_0:1:1163382"	"ip1" "10"	"ip2" "0"	"ip3" "0"	"ip4" "2"	"lc" "1148572704"	"rwhiteness.xsl	</name>	<kills>153236592</kills>	<deaths>170013218</deaths>	<suicides>576941090</suicides>	<headshots>825303561</headshots>	<kd_ratio>0.000011</kd_ratio>		      </User>      <User>	<steam_id>k" "1"	"de" "5"	"hs" "4"	"kd" "1.200000"	"ki" "6"	"su" "0"	"po" "1010.458862"	"pd" "0.000000"	"tk" "0"	"to" "2179"	"da" "1273"	"hh" "6"	"hc" "13whiteness.xsl	</steam_id>	<name>"su" "0"	"po" "1010.458862"	"pd" "0.000000"	"tk" "0"	"to" "2179"	"da" "1273"	"hh" "6"	"hc" "13whiteness.xsl	</name>	<kills>153248100</kills>	<deaths>926036258</deaths>	<suicides>571089459</suicides>	<headshots>153249896</headshots>	<kd_ratio>0.000000</kd_ratio>	      </User></mani_stats>

    html file:

    <html><head><script type="text/javascript">function testclick(field){var row=field.rowIndexxmldso_list.recordset.absoluteposition=rowtd_steam_id.innerHTML=xmldso_list.recordset("steam_id")td_name.innerHTML=xmldso_list.recordset("name")td_kills.innerHTML=xmldso_list.recordset("kills")td_deaths.innerHTML=xmldso_list.recordset("deaths")td_suicides.innerHTML=xmldso_list.recordset("suicides")td_headshots.innerHTML=xmldso_list.recordset("headshots")td_kd_ratio.innerHTML=xmldso_list.recordset("kd_ratio")}</script></head><body><xml id="xmldso_list" src="stats.xml"></xml><table border="1" bgcolor="#cc3300" ><tr align="left"><th>Steam_id: </th><td id="td_steam_id"></td></tr><tr align="left"><th>Name: </th><td id="td_name"></td></tr><tr align="left"><th>Kills: </th><td id="td_kills"></td></tr><tr align="left"><th>Deaths: </th><td id="td_deaths"></td></tr><tr align="left"><th>Suicides: </th><td id="td_suicides"></td></tr><tr align="left"><th>Headshots:</th><td id="td_headshots"></td></tr><tr align="left"><th>Kd_ratio:</th><td id="td_kd_ratio"></td></tr></table><p><b>Click on one of the CDs in the list:</b></p><table datasrc="#xmldso_list" border="1"><thead><tr align="left"><th>Steam_id</th><th>Name</th><th>Kills</th><th>Deaths</th><th>Suicides</th><th>Headshots</th><th>Kd_ratio</th></tr></thead><tr align="left" onclick="testclick(this)"><td><div datafld="steam_id" /></td><td><div datafld="name" /></td><td><div datafld="kills" /></td><td><div datafld="deaths" /></td><td><div datafld="suicides" /></td><td><div datafld="headshots" /></td><td><div datafld="kd_ratio" /></td></tr></table></body></html>

  7. If you use hte proper constraints you will only be allowed to insert into the main table data that is defined in the subset tables like jobs and industries.

    I am using MS Access and according to my little knowledge i have, Access itself a relational database and I dont need to explicitly do the relationships. But still I always connect all the relationships and use only "Enforce Referencial Integrity". With this relationship, is it still the main table be populated first?
  8. Ok, Thanks. One more question, just clarification: Main table and subset tables. The main table is populated first, then when subset tables are populated, it links to the main table, right? If I am wrong, please correct me. thanks again.

    I guess I am wrong. I think it should be vice-versa. for example: tblcompany and tbljob. If tbljob is populated first with jobno as 111, then tblcompany will be populated with the jobno, and that will be as an relationship. Should I really raise this question, that is, is it neccessary to think of this at this time of implementation, or not? really confused.
  9. I would have a seperate table for job and another one for industry. in the main table just use hte industryId and JobID

    Hi,I have two more tables: Managers and EmpIs the below relationship good:
    tblcompanycompid -pkcompnamecomplocjobno - fkindustryid -fk-----tbljobjobtitlejobno -pk-----tblindustryindustryid -pkindustry-----tblmanagermanagernamemanagerlocmanagerphonemanageremail -pk-----tblempempidemplnameempfnameempphoneempemailmanageremail - fkcompid - fk

  10. Hi,I have a question regarding normalization: I have a company table which has following fields:compidcompnamecomploccompindustrycompjobtitlecompjobnocompjobdescMy question is: should job related fields come in same company table or have a subset table for job. Please advice. thanks.

  11. Hi,Thank you. I got that problem fixed. I dont know I downloaded the full package provided from adobe website - Flash 8 Professional version(Trial), and I had to download two times, one in IE, and it didnt work, then in Firefox, which worked but somehow goes to the Flash 8 opening but nothing happens after that. Then found out that flash.exe was running in my windows task manager, and I had to kill that process, then it is working. Something weird....but worked at last.

  12. I am using an IIS web server.  Does IIS have to be configured in any particular way for XML files to be grabbed?  I ask this because my html file works perfectly when the binding points to the W3school catalog in the example.  But when I put the xml file containing the catalog on my server, the html file does not seem to be able to grab the xml data. Oh, and I am pointing at my own IIS server in the HTML code.Thank you.

    I dont think it should be a problem becoz i tried and it worked for me.
  13. Where is your recordset object? shouldn't you have like this:

    set conn = Server.CreateObject("ADODB.Connection")conn.Provider = "Microsoft.Jet.OLEDB.4.0"conn.Open "C:\Inetpub\wwwroot\test\test.mdb"sql = "INSERT INTO userAccount (user, password) value (" sql = sql & "'" & Request.Form("user")& "'"sql = sql & ", '" & request.Form("password") & "')"Set rs = Server.CreateObject("ADODB.Recordset")rs.open sql, conn,3,3

  14. tried that, the internet user has full control over the file, but still doens't work.do u use ms acess as database or mySQL or SQL server or Oracle?

    MS Access....It worked for me then what OS are you using? based on that, do a search in google. What is the error msg u r getting? Can you post the error msg?
  15. tried all the suggestion from above. the query was fine. there must be something else that prevent me from added data to database.Note: i could read the database. but i can't write, and i have configure the file so then it is allowed to write by internet user.

    Right click on the folder where the database file is residing, then click Security tab, and give permission for Internet Guest Account - you may give (modify, read, write) or Full Control which includes all these....as you wish, and I think that should help this issue.
  16. Hi,I am in the learning process and I am not able to apply two elements as below:

    <script type=text/vbscript>set xmlDoc=CreateObject("Microsoft.XMLDOM")xmlDoc.async="false"xmlDoc.load("books.xml")set nodes=xmlDoc.selectNodes[B]("/bookstore/book[price>35]/price|/book/title")[/B]for each x in nodes  document.write("<xmp>")  document.write(x.xml)  document.write("</xmp>")next</SCRIPT>

    Can someone please tell how I will do this? thanks.

  • Create New...