jojay
-
Posts
69 -
Joined
-
Last visited
Content Type
Profiles
Forums
Events
Posts posted by jojay
-
-
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.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> -
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?In above code, lastName is my database field.Cheers,PRANAV -
Check the link below:http://www.devx.com/vb2themax/Tip/18635I want to code for clearing cache in asp -
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:Hi again..Is it possible at all to make anything out of this server_stats.xml??<?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> -
Ok, Thanks.You still need to define the relationships and the subtables will need to be populated first. If you set everything correctly you wil get errors if you try and populate the main table first -
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?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 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.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. -
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.looks good to me
-
Hi,I have two more tables: Managers and EmpIs the below relationship good:I would have a seperate table for job and another one for industry. in the main table just use hte industryId and JobIDtblcompanycompid -pkcompnamecomplocjobno - fkindustryid -fk-----tbljobjobtitlejobno -pk-----tblindustryindustryid -pkindustry-----tblmanagermanagernamemanagerlocmanagerphonemanageremail -pk-----tblempempidemplnameempfnameempphoneempemailmanageremail - fkcompid - fk
-
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.
-
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.
-
I dont think it should be a problem becoz i tried and it worked for me.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. -
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>
-
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....
-
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"
-
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 -
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
-
Below link also will help:http://www.w3schools.com/web/default.asp
-
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?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? -
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.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. -
selectnodes
in XML
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.
-
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
-
Its okay. I got it. I was looking for this syntax to search values in a field. Below code works great:What exactly do you want then?SELECT Clname from Cform WHERE Clname like '%" &Clname& "%'
Thank you all for your contribution. It will surely be helpful.
-
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.....Actually, the %-wildcard counts for MySQL 4, and has the same meaning as the *-sign, which maybe has been added in later versions, I don't know. So the % sign may be used instead of the *, if someone confirms it has tod o with the MySQL version.And maybe that is also why you think SQL needs a semicolon at the end of the query, which is not true for MySQL version whatever, but that you use a different database which does need it :)So remember, a semicolon (;) is not always neccesary in SQL, and a % sign inside the LIKE phrase is also allowed as wildcard
Editing & Updating Xml files
in XML
Posted