|
If have a section of code in my AgencyRegistrationProcess.asp page.
It does 3 additions to the database after one another.
It adds agency data to the agency table.
Then it adds the agent data to the agent table.
Then it adds the subscription data to the subscription table.
I have an error test on this that when there is a violation of the primary key then it will complain. I am doing this test on all 3 tables. Now, lets say the agency data is added to the agency table, and for some or other reason the agent and subscription details are already in the database. This will cause an error because of a primary key violation. Now how do I go one step back and delete the data that was entered into agency table. Data should only be entered if all three of them are valid.
Thanks
Brendan
|
|
|
|
|
I have a province combo, and a region combo, and an area combo. When a user selects a province, all the regions for that province must load. When the user selects a region, all the areas for that region must load. This works well. But my problem comes now. Once you have chosen the province, the region, and the area, select a different province. The new regions should load for that province, and because no region has been selected at this stage, there should be nothing loaded in the area combo. I do not know how to code this. I have been struggling and debugging for some time now. Nothing seems to work. The only way that I can get this right is if I do it in JavaScript. I want it done in ASP.
Here is my ASP code which is at the top of the page:
<%
'------------------------------------------------------------------------------------
' Variable declaration
'------------------------------------------------------------------------------------
Dim objForm
Dim intProvince: intProvince = 0 ' Default value
Dim intRegion: intRegion = 0 ' Default value
Dim intArea: intArea = 0 ' Default value
Dim boolIsPost
Dim intReferenceType, intSubscriptionType
' Connection and recordset variables goes here...
'------------------------------------------------------------------------------------
' Determine whether post is successful
'------------------------------------------------------------------------------------
boolIsPost = CBool(Request.Form("IsPost"))
If boolIsPost Then
' Get the numeric value of the selected index of the province combo
intProvince = CInt(Request.Form("province"))
' Regions and area should only load if a province is selected
If intProvince > 0 Then
intRegion = CInt(Request.Form("region"))
Else
intRegion = 0
End If
If CInt(Request.Form("region")) > 0 Then
intArea = CInt(Request.Form("area"))
Else
intArea = 0
End If
End If
'intArea = CInt(Request.Form("area"))
intReferenceType = CInt(Request.Form("cmbReferenceType"))
intSubscriptionType = CInt(Request.Form("cmbSubscriptionType"))
%>
The code that I have in my to load each combo is below. I have a function that loads the combo depending on the parameters:
Province combo:
<%
' Define SQL statement and open it
strSQL = "SELECT ProvinceID_PK, ProvinceName " & _
"FROM tblProvince " & _
"ORDER BY ProvinceName;"
objRs.Open strSQL, objConn, adOpenForwardOnly, adLockReadOnly
' Create and instance of the form class
Set objForm = New Form
Response.Write objForm.GetList("frmAgencyReg", "province", objRs, 0, 1, intProvince, True, True, False)
Set objForm = Nothing
' Close the recordset
objRs.Close
%>
Info »
Region combo:
<%
' Define SQL statement and open it
strSQL = "SELECT RegionID_PK, RegionName " & _
"FROM tblRegion " & _
"WHERE ProvinceID_FK = " & intProvince & " " & _
"ORDER BY RegionName;"
objRs.Open strSQL, objConn, adOpenForwardOnly, adLockReadOnly
' Create and instance of the form class
Set objForm = New Form
Response.Write objForm.GetList("frmAgencyReg", "region", objRs, 0, 1, intRegion, True, True, False)
Set objForm = Nothing
' Close the recordset
objRs.Close
%>
Info »
Area combo:
<%
' Define SQL statement and open it
strSQL = "SELECT AreaID_PK, AreaName " & _
"FROM tblArea " & _
"WHERE RegionID_FK = " & intRegion & " " & _
"ORDER BY AreaName;"
objRs.Open strSQL, objConn, adOpenForwardOnly, adLockReadOnly
' Create and instance of the form class
Set objForm = New Form
Response.Write objForm.GetList("frmAgencyReg", "area", objRs, 0, 1, intArea, True, False, False)
Set objForm = Nothing
' Close the recordset
objRs.Close
%>
Info »
Because I have a Request.Form for each field to retain the values when the page makes a trip to the server. How do I clear all the values when the page is refreshed?
This doesn't make much sense, so I am willing to send my files if requested.
I require help!!!
Thanks
Brendan
|
|
|
|
|
I use the vbTab string constant in a element. The data is tabbed correctly in Internet Explorer, but it does not display correct in Netscape Navigator. How do I correct this? Below is how my data is displayed:
Internet Explorer:
Name: [put your name and surname here]
Telephone: [put dialimg code and contact number here]
E-mail: [put e-mail address here]
Netscape Navigator:
Name: [put your name and surname here]
Telephone: [put dialimg code and contact number here]
E-mail: [put e-mail address here]
Below is how I write my text to the <textarea> element:
Response.Write("Name:" & Chr(9) & Chr(9) & "[put your name and surname here]" & Chr(10) & Chr(10))
Response.Write("Telephone:" & Chr(9) & "[put dialimg code and contact number here]" & Chr(10) & Chr(10))
Response.Write("E-mail:" & Chr(9) & Chr(9) & "[put e-mail address here]")
I hope some can look into this for me.
Thanks
Brendan
|
|
|
|
|
Where can I find more info on the RegExp object? I need it to check my data and confirm whether a URL is valid or not.
|
|
|
|
|
I found the following code with regards to e-mail validation. I don't really understand what is going on here. Is this a safe way of validating? Where can I find more about this topic? Also, I need to validate a URL. How will it differ from e-mail validating? Here is the code I found for validating an e-mail field:
function isValidEmail(email)
{
var validFormatRegExp = /^\w(\.?\w)*@\w(\.?[-\w])*\.([a-z]{3}(\.[a-z]{2})?|[a-z]{2}(\.[a-z]{2})?)$/i
var isValid = validFormatRegExp.test(email);
return (isValid);
}
|
|
|
|
|
I'm not good with regular expressions, but I would suggest you read up on them. This code validates the email address using a regular expression.
Glenn
|
|
|
|
|
Hi
my problem is that I need to use certificates that use different key stores as the ones that are built into windows. I have tried with little success to still use CAPICOM. My question is this - does anyone know about a good alternative when it comes to working with certificates and keystores or am I missing something with regards to CAPICOM?
thanks in advance
Gavin Jeffrey
|
|
|
|
|
hi code guys!
I wana access all the contents from loaded page in my app having Web Browser Control frame by frame.
pls tell me how to get the total frames in my app. and also how to access contents of frames.
thanks!!
|
|
|
|
|
When you save a web page[ for example http://www.microsfot.com/China] to your favorites folder, you will be saving it as a short cut with a descriptive name which goes into a folder in your computer. The format of this will be generally *.url. Now is there a way to get the original string [http://www.microsoct.com/China] from the *url [aliased] file name programmatically.
|
|
|
|
|
It's just a text file. Drop it inot notepad to see the format and you can the parse it in your own code to get the url you need.
|
|
|
|
|
this table fails to resolve properly with IE. THe top left cell is the problem -
http://mule.med.harvard.edu/test.html
here is the code:
<table width="643" height="493" border="1" cellpadding="2" cellspacing="5">
<tr>
<td width="321" height="25" bgcolor="#CCCCCC">321x25</td>
<td width="321" height="241" rowspan="2">321x241</td>
</tr>
<tr>
<td height="318" rowspan="3">321x318</td>
</tr>
<tr>
<td height="25" class="style8">321x25</td>
</tr>
<tr>
<td height="26" bgcolor="#CCCCCC" class="style7">321x25</td>
</tr>
<tr>
<td height="25" bgcolor="#CCCCCC" class="style8"><span class="style7">321x25</span></td>
<td height="202" rowspan="6">321x202</td>
</tr>
<tr>
<td height="25" bgcolor="#CCCCCC" class="style8"><span class="style7">321x25</span></td>
</tr>
<tr>
<td height="25" bgcolor="#CCCCCC" class="style8"><span class="style7">321x25</span></td>
</tr>
<tr>
<td height="25" bgcolor="#CCCCCC" class="style8"><span class="style7">321x25</span></td>
</tr>
<tr>
<td height="25" bgcolor="#CCCCCC" class="style8"><span class="style7">321x25</span></td>
</tr>
<tr>
<td height="25" bgcolor="#CCCCCC" class="style8"><span class="style7">321x25</span></td>
</tr>
</table>
end code
any idea why? It works in mozilla/firefox...
|
|
|
|
|
Whenever there is code that can be interpreted differently by two browsers, it will probably happen.
In this case, you have given the browser the task of taking something of height 343 on the LHS, and told it that it must be the same height as the RHS, which is 391.
Mozilla took one approach, which was to render the LHS correctly, and the top RHS cell incorrectly. IE took another approach, and appears to apply the cell heights proportionally. Go figure.
my blog
|
|
|
|
|
Hello,
currently I'm fighting with the problem of making ISAPI URL filter for guarding unauthorized access to the files stored in the ASP.NET site (not .aspx files). I tried to use the temporary cookie for listing the folders you could access. I access the cookie info through ALL_RAW server variable. It works well on my computer (IIS 5.0), however the solution does not work on my coleguage's XP machine (IIS 5.1). Whereas on my computer the ALL_RAW contains the asp session cookie, the asp webforms authorization ticket cookie and the special cookie with the list of directories user is authorized to access, on his computer I lack a them. The HTTP_REFERER variable is empty on his computer too.
The filter is normal ISAPI filter and the code takes effect only inside of the ASP.NET application.
Does anyone any idea why it is so? Please help, any comments appreciated.
Thanks
Vasek
Vasek
VB6, C#, MS DNA, MS.NET
Software Developer
|
|
|
|
|
Greetings,
Has anyone attempted to read and write ini files using VBScript? Several possible methods come to mind. Before I head down the trial and error path I thought I would ask if anyone else has already found a solution.
TIA,
Steve
No matter where you go, there you are.
|
|
|
|
|
If VBScript is anything like JScript FSO(File system object) is the only way to go.
Cheers 
How do I print my voice mail?
|
|
|
|
|
Unfortunately, using the FSO would require the recreation of the whole funtion. I was hoping for a means to implement the GetPrivateProfile function with VBScript.
|
|
|
|
|
There is no way, except for using COM objects(JScript anyways) a script can access anything in the windows API.
How do I print my voice mail?
|
|
|
|
|
I have an XML file that is a template for presenting some of our output data. The XML template file is read and manipulated with the XML DOM in C++ code to customize some of the contents. A separate XSL file is available to transform XML tags into pretty HTML, and since my XML file uses these tags, I can see the nice HTML display.
In order not to have to send around and manage both the XML and XSL files (the XSL file I have no control over), I would like to now start with the HTML file, and using the XML DOM, manipulate its contents.
The problem: how can I save the "rendered" HTML tags that are the result of the XSL transformation? Once the HTML is in a web browser, clicking on SaveAs only saves the original XML, not the rendered HTML. I've also tried JavaScript to transform the XML using the XSL, but saving that only saves the original page containing the JavaScript.
Any suggestions?
Dave
"You can say that again." -- Dept. of Redundancy Dept.
|
|
|
|
|
There is a s/w available for download.It gives you the rendered HTML tags. The link is http://www.topxml.com/xselerator/download.asp .Hope this will help you.
|
|
|
|
|
our current classic ASP application draws some custom round-ended buttons by doing something like this:
<br />
<table border='0' cellpadding='0' cellspacing='0'><br />
<tr><br />
<span onclick="<%= target_url%>"><br />
<td><img src="leftside.gif"></td><br />
<td background="button_middle.gif"><%=GetButtonText%></td><br />
<td><img src="rightside.gif"></td><br />
</span><br />
</tr><br />
</table><br />
basically, it works because a SPAN can handle an onclick event.
well now i've been asked to write a class to do this in C#, and i don't have a clue where to begin. is this something you can handle by overriding the standard button C# class, or would this be some other kind of web control, or... ?
any help is appreciated.
Software | Cleek
|
|
|
|
|
Have a look in the articles, someone has already posted a .Net control for creating rounded displays.
If not, you can extend the button control or the basic System.Web.Control to create your own server control, basically you just add the html you need during the Render method, again there are plenty of articles here already explaining how to do this.
|
|
|
|
|
ChrisAdams wrote:
again there are plenty of articles here already explaining how to do this.
i looked and didn't find any that looked promising. i realize this is probably very basic stuff...
-c
Software | Cleek
|
|
|
|
|
I am trying to create an intranet site that allows users to browse the telephone and other information about users in my Exchange 2000 directory. I know that this can be done with ASP and ADSI through the LDAP protocol, but i cannot get it to work. when i try to do a get object for an ADsPath like "LDAP://cfbc2k1/Users/" i get an error. (BTW: cfbc2k1 is my exchange server and domain controller, the domain is called cfbc.org). When enumerate the children of "LDAP://cfbc2k1", all i get is "CN=Builtin". I can access the usernames and descriptions with "WINNT://cfbc2k1", but I don't know how to get the address book type information like phone numbers.
i have read the article "Exchange Server, ASP and ADSI / LDAP" on this site at: http://www.codeproject.com/asp/Exchange_ADSI_LDAP.asp, but i can't get the example to work
thank you in advance for any help
Brad Dodson
Champion Forest Baptist Church
|
|
|
|
|
Hi Brad,
I am sure this link http://www.cdolive.com/kb.htm[^] will definitly solve your problem, there are several knowledge base articles on accessing MS Exchange Server.
Take some time to go through these and be happy.
Happy Programming,
The Phantom.
|
|
|
|
|
I have designed a web site. In page download, user can download items
by click on hyperlink (download example).
I implemented this by add hyperlink, but user click on, it always open the download file on browser. I want it show the save dialog.
How can i do this.
Thanks.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
