Jump to content


  • Posts

  • Joined

  • Last visited

jojay's Achievements


Newbie (1/7)



  1. jojay

    Upload Video

    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. jojay

    Web Design

    I want to learn web design more of design layouts, navigation, etc. Can some one please suggest a good site to learn these stuffs?
  3. jojay

    Excel Problem

    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.
  4. 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.
  5. jojay

    Script error -

    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.
  6. jojay

    ASP Error

    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?
  7. Check the link below:http://www.devx.com/vb2themax/Tip/18635
  8. jojay

    Bind xml to html

    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>
  9. jojay

    normalization question

    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?
  10. jojay

    normalization question

    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.
  11. jojay

    normalization question

    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.
  12. jojay

    normalization question

    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
  13. 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.
  14. jojay

    flash trial download

    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.
  • Create New...