Jump to content

jojay

Members
  • Posts

    69
  • Joined

  • Last visited

jojay's Achievements

Newbie

Newbie (1/7)

0

Reputation

  1. 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.
  2. 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.
  3. 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?
  4. Check the link below:http://www.devx.com/vb2themax/Tip/18635
  5. 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>
  6. 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?
  7. 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.
  8. 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.
  9. 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
  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. 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.
  12. jojay

    Bind xml to html

    I dont think it should be a problem becoz i tried and it worked for me.
  13. jojay

    Bind xml to html

    In your xml document, add < tag in the first line. <?xml version="1.0" encoding="ISO-8859-1" ?> Then take out all the - in front of the CD, it should work fine. -<CD>
  14. I downloaded the trial version of Flash and it downloaded everything but not able to open. Not able to figure out what may be the problem. I even restarted my computer but no luck....
×
×
  • Create New...