I have this statement that I need to execute:
DELETE FROM callcenter..tRecipQueue WHERE DATEDIFF(dd, expiration_date, GetDate()) > 368
Of course it doesn't work because expiration_date is a varchar data type, which contains MM/DD/YYYY value. How can I efficiently cast or convert that data, so...
I will try to make some sense of this as best as possible. I have a page that contains a form and a few asp controls. I also have an iFrame that points to a simple aspx page with a RadioListButton, which loads images from the server dynamically. what I would like to do is have the...
I am trying to have an array of images in a RadioButtonList, which is working, but I need to set the values (Image file names) to each item within the RadioButtonList, but I am having some difficulties.
I have this so far:
asp:RadioButtonList ID="radiolist1" runat="server"...
I'm not sure where to start, but I have this problem I ran into:
I have a CheckBoxList, which I loop through each item in the list and then send the string value to a table.
For Each li In view_description.Items
If li.Selected = True Then
ListBoxItems = ListBoxItems & li.Value & ","...
I forgot what to do in a case like this. I have a SqlDataSource control within a label and I want to allow auto sorting, but when I click on the sort link the page comes back with:
The SqlDataSource control 'sqlViewIncompleteForms' does not have a naming container. Ensure that the...
I am having a little issue with an error that is frustrating me. I have a SqlDataSource within an asp:label control and also have a two dropdownlists inside that asp:label control also. When I select from the first dropdownlist, it should enable the second dropdownlist with the populated...
Normally when you received this message is it coming from the db, or the code itself?
Sub Calendar1_DayRender(ByVal sender As Object, ByVal e As DayRenderEventArgs)
'Dim calid As Integer = CInt(Page.Request.QueryString("calid"))
Dim calid As String = 0
I am having some difficulties with this. I read somewhere to use this:
OnClientClick="window.document.forms.target='_blank';" PostBackUrl = "/_MembersOnly/MemberProfile/EditProfileRedirect.asp"
which works great, but when I close EditProfileRedirect.asp and then click on another link on...
I am in a delima here. I have a membersonly section that our users log into. I am passing a tokenkey to verify the session and to prevent others from hacking, sharing, ect info. I am setting the tokenkey to a session.item("sesTokenKey") in the codebehind.
Now we created a page in...
I have come to a tricky part of my webproject. This maybe a bit confusing.
As of now I have two sqldatasources:
<asp:SqlDataSource ID="sqlBrokersAgentsRecips" runat="server" ConnectionString="<%$ AppSettings:connectionstring %>" ProviderName="System.Data.SqlClient"...
I hope I can make sense of this. I have exhausted all resources, MSDN and books, but cannot understand or figure how I can programmatically change and write out a different value of a datafield?
One of my datafields returns an on/off switch, (0,1), so depending on the value, I want to...
Hello, in my event view log for applications, I see quite a few of these messages:
Event Type: Warning
Event Source: ASP.NET 2.0.50727.0
Event Category: Web Event
Event ID: 1309
Time: 2:57:01 AM
I need to send two seperate message one to the the client, who is actually CC and another message that is sent to their broker, but with limited information. Its basically a confirmation message (registration application online) that the client fills out.
I have this so far...
Hello all, I am currently upgrading our webproject that was in 1.1 used with VS 2003 and using VS2005 to upgrade to 2.0. I received quite a few dozen errors. I have been using this site as a reference:
but it seems as much as I keep reading and try and debug more erros happen. I believe I...
I was doing some testing and have a few problem, which leads to a simple question (hopefully).
I have a memberapp.aspx page, which is a general application, when the users fills the form out, they click a Next button to go to another page. The second page is called...