|
I'm programming in classic ASP but I didn't see a forum for this so I post it here. I hope somebody can help me. 
I have 2 tables, empID and deadEmpID. My app generates a new employee ID by getting the value of NEXTVAL (sequencial # from Oracle). The deadEmpID table contains a few numbers that we can not use as an employee ID so before inserting nextval into empID, I need to check to make sure this number is not in the deadEmpID table. When I run my program, if the new generated id is not in deadEmpID then it's fine... but if exists in deadEmpID, it keeps running until time out. What am I doing wrong here, please help!!
(When you reference the nextval from your sql statement, it increments to the next sequence # .)
getNextVal = "select emp_id_seq.nextval as NextEmpID from dual"
Do While True ' loop forever
Set oRS = oConnDB.Execute( getNextVal )
sNextEmpID = oRs("NextEmpID")
oRS.Close
' compare nextval make sure it's not in dead table
checkDead = "select deadID from deadEmpID where deadID = '" & sNextEmpID & "' "
Set oRS = oConnDB.Execute( checkDead )
If oRS.EOF Then Exit Do ' that empid not in dead table
Loop ' we'll go back and get another nextval and try again
'insert into employee table
sSQL = "insert into empID (empID, lname, fname) values (emp_id_seq.curval, '" & sLastName & "', '" & sFirstName & "')"
oConnDB.Execute(sSQL)
|
|
|
|
|
kl010705 wrote: I'm programming in classic ASP but I didn't see a forum for this so I post it here
Should have used VB Forum instead 
kl010705 wrote: I have 2 tables, empID and deadEmpID
deadEmpID, nice name
Anyways, have you ever heard of break keyword. You will need to break your look once you find the new generated empid in the existing table.
Hope this helps![Rose | [Rose]](https://codeproject.global.ssl.fastly.net/script/Forums/Images/rose.gif)
|
|
|
|
|
My God, I didn't really notice until you told me about the variable name!
I'll try 'break'. Thank you for your suggestion!
|
|
|
|
|
Hi guys,
In my ASP.NET website I have several custom controls which make use of the Page.ClientScript.GetPostBackEventReference method to achieve postbacks from client javascript. Up until now this has worked like a charm, however I find myself with a difficulty.
GetPostBackEventReference generates a reference which allows one control reference and one argument to be passed from the client to the server. Is there already a mechanism in place to parse multiple arguments from the client to the server?
It isn't the end of the world if there isn't because I could manually parse a single string into multiple arguments.
Many thanks!
Lea Hayes
|
|
|
|
|
Hi,
I have worked out a slightly different way of achieving what I need. Instead of manually adjusting the postback reference I have just realized that I can use hidden fields to achieve what I need.
For those interested,
1. I register the hidden field via
Page.ClientScript.RegisterHiddenField("MyFieldName", "InitialValue");.
2. This value can then be altered by javascript
document.getElementById('MyFieldName').value = 'AdjustedValue';
3. Then this value can be retrieved again on the server by:
string requestedValue = Page.Request.Form["MyFieldName"];
And that's all there was to it!
Thanks anyhow,
Lea Hayes
|
|
|
|
|
If you want to get client values,there are four methods.
one is ViewState,two hidden control,three session,four request.query or request.form.
studing is processing in this life.
|
|
|
|
|
Hi,
Thank you for your advice...would you be able to demonstrate how to access the view state object from the client script language? I was under the impression that the view state was not accessible by the client because it is encrypted, and compressed.
I would also be interested in an example for the accessing session information via the client.
I understand how the hidden controls, request.query, and request.forms alternatives work.
Thanks!
Lea Hayes
|
|
|
|
|
In fact,ViewState is the same as Session.
button1_click()
{
ViewState["test"]=TextBox1.text;
string temp=ViewState["test"];
Response.write(temp);
}
studing is processing in this life.
|
|
|
|
|
Hi,
I am getting an exception when i am loading xml string into the XmlDocument using LoadXml()
MyCode:-
string str="<3rdperson></3rdperson>";
XmlDocument xdoc=new XmlDocument();
xdoc.LoadXml(str);
I am getting the following exception :-
System.Xml.XmlException: The '3' character, hexadecimal value 0x33, cannot begin with a name. Line 1, position 2.
|
|
|
|
|
salmonraju wrote: System.Xml.XmlException: The '3' character, hexadecimal value 0x33, cannot begin with a name. Line 1, position 2.
Didnt the exception explain the reason. 
Well, keep in mind that an Xml tag can never start with an integer. ![Rose | [Rose]](https://www.codeproject.com/script/Forums/Images/rose.gif)
|
|
|
|
|
Thank you Manas, Is there any solution for this..
|
|
|
|
|
Hi!
There are several options you could choose:
1. Specify type of perspective as an attribute:
[This would be my personal choice because it is slightly more flexible, and it would be easy to extend the markup to include '1st' person without having to deal with additional element types.]
<person type='3rd'>
</person>
2. Use word form of '3rd':
<third-person>
</third-person>
3. Place '3rd' at end of name:
<person-3rd>
</person-3rd>
Hope that this is of help!
Lea Hayes
|
|
|
|
|
|
hi 2 all,
i am using Visual studio 2005 and Sql Server 2000.
i wanted to associte the values retrived from the database with the Radio Button List.
the Number of values retrived from Database is arbitrary.
Please explian it to me in detail,as m really new to dis field..
Thanx
|
|
|
|
|
User the datasource property of the radiobuttonlist.
once specifying the datasource, to the databind
|
|
|
|
|
hey Manas,i need to run some Sql query form the Database as well.
can i get the same in Grid View..?
pl explian bro..
thanx
Amit...
|
|
|
|
|
its work like drop down list box fill.
i think its usefull for us. try it
|
|
|
|
|
how can i enlarge a dropdown list scroll bar??
|
|
|
|
|
You are joking?!
This is such a silly question
|
|
|
|
|
That depends on what you want to do.
Do you want to extend enlarge the actuall size of the Scroll Bar, or the height of the Dropdownlist??
|
|
|
|
|
I am talking about the width of the scroll bar, not height.
|
|
|
|
|
I'm pretty sure this isnt possible
|
|
|
|
|
hi i am new user of dot net.
my problem is that i use a master page and master page is fill with categories from tbl_catgory.
when i use <asp:contentplace xmlns:asp="#unknown"> to before datalist then datalist given error with datalist its run but problem is that design is not ardujest like there are 500px space and list is more than 500px then data goes outside the panel.
i use ifrmae but when i click in any link that open in that iframe.
what i do to remove my errors.
thanks in advance.
|
|
|
|
|
Ok. What little I can get from the above mess, is that your Datalist is not working and when you bind your data from the database it extends past the given width of the panel.
Well for the Datalist error if you could post the Error that would help.
I'm assuming that your panel is being Extended to far. Are you using a table, or is the datalist the only thing in the Panel.
|
|
|
|
|
<asp:datalist runat="server" id="dl_c" onitemdatabound="dl_c_ItemDataBound" width="100%" onitemcommand="dl_c_ItemCommand" xmlns:asp="#unknown">
<itemtemplate>
<asp:linkbutton runat="server" id="btn1" commandname="add">
|
<asp:literal id="lt_des" runat="server">
|
|
(1) problem nullvalueexception in term i used this datalist in contentplace holder in master page.
(2) without contentplace holder its fill well but its goes out from panel.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
