Jump to content

jojay

Members
  • Posts

    69
  • Joined

  • Last visited

Everything posted by jojay

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

    error: insert into

    If you dont get through still, then try the below code: conn.Provider="Microsoft.Jet.OLEDB.4.0; Data" & _ "Source=c:\Inetpub\wwwroot\test\test.mdb"
  16. jojay

    error: insert into

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

    error: insert into

    If you still get error message, try to response.write and see .below the sql statement, write the code after sql statement:response.write sql
  18. Below link also will help:http://www.w3schools.com/web/default.asp
  19. jojay

    error: insert into

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

    error: insert into

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

    selectnodes

    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.
  22. I dont understand fully what you are trying to say but if you are trying to update fields then you have to use update statement. Below is a link as example for update statement:http://www.w3schools.com/sql/sql_update.asp
  23. jojay

    like operator

    Its okay. I got it. I was looking for this syntax to search values in a field. Below code works great:SELECT Clname from Cform WHERE Clname like '%" &Clname& "%' Thank you all for your contribution. It will surely be helpful.
  24. jojay

    like operator

    Thank you all. I am using MS Access database and using the sql code in asp and it doesnt allow a semicolon, it gives an error. I am using this sql code to search the values of a field in the database, and I dont want to get to specific resultsets such as "ja*" or "*ja". Should I create a variable for Clname(field name in the database) then use it in the code? Not yet there.....
×
×
  • Create New...