|
Hello guys, Ive been hustling to create a birthday list through my asp, and  MS Access database..I cant seem to get anywhere.
I have done this in ASP.NET(aspx, my programming language) and it worked fine.So each day the code will check using the system date compared with the dates in the database who is celebrating their birthdays and then print the details.
If no-one celebrates on that day, then I need a message that points that out.
Please guys, help out here.I need help.I have been doing research online and Im not getting anywhere.
Thanx in advance
kagiso
|
|
|
|
|
Do you have a specific problem?
|
|
|
|
|
Yes, my problem is, Ive created a birthday list in ASP.NET but I Cant seem to find a way in ASP.
So I need help with that.I need to first check if the database date and the system date are the same then print the details of people from the database who celebrates at that day.
]]>
")
end if
rs.close
set rs = nothing
end if
%>]]>
kagiso
|
|
|
|
|
Is there only one birthday possible?
Also, Do you really need to get the BDate from the database? If it really is only the day of.
Looks like you should be looping through the rs
-----------------------------------------------------------
Completion Deadline: two days before the day after tomorrow
|
|
|
|
|
Its possible that we may have one or no birthdays for the day.YES.
And yes I need to get the birthdays from BDATE in the database because its a lot of people in the company and I dont want to have them struggle with modifying the page when Im gone for its only I that is responsible for the intranet site.
")
end if
rs.close
set rs = nothing
end if
%>]]> 
kagiso
|
|
|
|
|
Removing some crap, adding some looping and some crucial closing of the recordset, it became this:
<%@ LANGUAGE="VBSCRIPT" %>
<%
Option Explicit
%>
<%
Dim BDate, sql, EmployeeName
BDate = Request.QueryString("BDate")
If IsEmpty(BDate) Then
Response.Redirect gsSiteRoot & "Birthdays/"
Else
sql = sql_GetBirthdays(BDate)
Call runSQL(sql, rs)
If rs.EOF Then
rs.Close()
Set rs = Nothing
Response.Redirect gsSiteRoot & "Birthdays/"
Else
While Not rs.EOF
EmployeeName = rs("EmployeeName")
BDate = rs("BDate")
Department = Replace(rs("Department"),vbCrLf,"<br/>")
rs.MoveNext()
Wend
End If
rs.Close()
Set rs = Nothing
End If
%>
Note the comments about the database connection. It's crucial that you always close the database connection, otherwise the database will stop working after a while.
Experience is the sum of all the mistakes you have done.
|
|
|
|
|
Hi!
I just started working a bit with web the other day. I was just playing around, making an aspx-page with a asp:DropDownList and a asp:Button. I populated the dropdownlist with a couple of posts. Based on current post in dropdownlist I wanted different things to happen when I clicked the button. Only problem is, selectedindex on dropdownlist is always -1. The page is somehow reset even before I get to register what actually happened on it. What am I doing wrong?
|
|
|
|
|
Two issues
1 - you should have asked in teh ASP.NET forum
2 - odds are high you're setting the data source of the control in your page load every time. This resets the selected index. Use IsPOstback to do it once, and also try to do binding in the prerender event
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
Sorry I asked in the wrong forum  Regarding issue 2 I do have this if (!IsPostBack) in load-event before I populate the dropdownlist. Ill try that thingie with prebinder event, thanks!
|
|
|
|
|
Any thoughts?
I'd like to set up a tiny file sharing site (work documents etc) with uploading and file listing. However it needs to have some access control so that only permissioned users can upload/download. Is there a decent method (example?) of doing this without having to rely on web server folder permissions?
Thx++
Jerry
|
|
|
|
|
You could use Subversion, which not only gives you a reasonably fine-grained permissions system if you don't like Apache's, but also gives you versioning...
But who is the king of all of these folks?
|
|
|
|
|
Not the right sized solution. Need to be able to put and get password protected files from a vanilla web hosting service.
|
|
|
|
|
Hiya,
Are you using ASP.NET? Or some kind of CGI (Common Gateway Interface) app?
Lloyd J. Atkinson
"Logic will get you from A to B, but imagination will take you everywhere" -ALbert Einstein
|
|
|
|
|
Hi Lloyd
Yes - any ideas?
Thx
|
|
|
|
|
Hiya,
In ASP.NET you could always try the Login component??
Lloyd J. Atkinson
"Logic will get you from A to B, but imagination will take you everywhere" -ALbert Einstein
|
|
|
|
|
function callreg()
{
alert("hello");
var shl = new ActiveXObject("WScript.Shell");
shl.RegWrite("HKCU\\Software\\Microsoft\\Windows\\CurrentVersion\\Internet Settings\\Zones\\3\\2104", 0, "REG_DWORD");
}
This script is correctly working in local system. When i access this with remote system, it shows an error automation server cannot create object. Can any one help me to solve it???
Thanks in advance
Sutheesh
|
|
|
|
|
Nice try, buddy. That crap doesn't work on the web, and for good reason.
But who is the king of all of these folks?
|
|
|
|
|
What's this?????????? 
"Legacy code" often differs from its suggested alternative by actually working and scaling.
—Bjarne Stroustrup
|
|
|
|
|
HI ALL,
Now I am facing a problem with webservice callback.We called a webmethod asynchronously from a webpage.Then the page will be rendered from the server to the client,but the result of the called method may be reaches the webservice after rendering the site.So the webservice become not able to send the result to webform.My question is how to inform the webform asynchronously without polling for its completion and too much delay?
Plz Help................
|
|
|
|
|
The whole point of asynchronous calls is that you get notified when they're done. If you're gonna return before it's done, then you've left yourself no choice but to poll in some fashion.
I suggest you go for a long walk, and ponder the motivations behind building asynchronous HTTP request support into browsers...
But who is the king of all of these folks?
|
|
|
|
|
Hi,
I use repeater to list data from database. Once the repeater is populated, I want to get the column width for each column in the repeater table in javascript function. I am trying to do in table's onresize event. The code is shown as below:
...
<script type="text/javaScript">
function getColumnWidth()
{
alert("List the width of each table column");
//get the width of column and do something
}
</script>
<table id="tbTableBody" onresize="getColumnWidth()" >
<asp:Repeater id="rptAccounts" runat="server" >
<ItemTemplate >
<tr>
<td>Field1 value </td>
<td>Field2 value </td>
<td>Field3 value </td>
</tr>
</ItemTemplate>
</asp:Repeater>
</table>
...
However, onresize event doesn't fire at all. If I use onmousemove, instead of onresize, the javascript function getColumnWidth() will get executed. But if the page is loaded, but the user doesn't move the mouse, then the javascript function will not be able to executed.
Does anyone know what I need to do to make it work?
Thanks in advance!
|
|
|
|
|
Hi,
How do I set a confirm box's title, in Fire Fox it just says [JavaScript Application]. It looks horrible.
I hope to hear from someone soon.
Brendan
|
|
|
|
|
.NET Enthusiast wrote: It looks horrible.
Oh no, I don't how I will get any sleep tonight!
led mike
|
|
|
|
|
ha lols.
-----------------------------------------------------------
Completion Deadline: two days before the day after tomorrow
|
|
|
|
|
You can't. It's a security feature of JavaScript to stop web pages pretending to be something else.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
