Search results for query: *

Never mind. I got it. SELECT distinct City, StateCode, count(*) as theCount FROM ZipCodes where country = 'USA' group by city, statecode order by statecode, city _______ I love small animals, especially with a good brown gravy....

I have a zipcode database. I need to list out the Cities in which there is only one record. The column is called "City" and the table is called "ZipCodes". For some reason my brain isn't firing on all cylinders today! _______ I love small animals, especially with a good brown gravy....

This is an online trucking company. A company account is created. This gets stored into a table. Let's call that table "CompanyAccounts" Then at the same time or shortly after, by retrieving the identity of that insert, we create the first or "master" log in account. That gets stored in...

I'm looking for some assistance in either getting a start in extending the ASP.NET 2.0 membership provider or purchasing someone's efforts. My business model requires the following: The main account that gets created is for the company purchasing our services. Once that account is create (it...

I'm trying to pass the pageindex of the gridview to the detailsview page so I can create a "back to list" button in Detailsview that will return the user back to the same page they were on. How can I grab the pageindex and pass it in a query string. I'm using VB.NET _______ I love small...

I resolved this issue. The problem was that there were spaces after the data in the database. So, the values didn't equal each other, therefore the item wasn't in the collection. By trimming the data within the SQL Select statement, I resolved this issue. _______ I love small animals...

I have a grid view with a button to send that record to a FormView page directly into Edit mode. On there there is the Update and Cancel buttons. How can I configure the Cancel button to take me back to the same spot in the Gridview that I came from? I know I can make a link to take me back...

Ok, I found what the issue was. I removed the DataSoureID="LWAdminLoadEdit" and it worked. Your code didn't hurt anything and I will assume it is better with your additions/subtractions. Now is there a way for me to actually populate the dropdown list from values using data from a database...

I thought I'd describe more of my troubles. Here is the code I have in place. <asp:TemplateField HeaderText="LDirection" SortExpression="LDirection"> <EditItemTemplate> <asp:DropDownList ID="Direction" runat="server"...

When entering the Edit mode of a DetailsView control, I would like to populate a DropDownList with all the possible values from a database. Then I would like to have the Value that was stored in that record to be selected. This will allow the user to see what the current selection is and allow...

tsuji, Thank you for catching what I should have seen! Sometimes I can't see the forest for the trees. _______ I love small animals, especially with a good brown gravy....

I'm trying to set multiple rows or values to selected based upon a query. It seems to set the "selected" but only the last value selected actually displays as selected. Anyone know what I am doing wrong? In the first part I take what is in the database, which is using the | to separate the...

I was hoping that this type of thing was more common. I recall having to edit some kind of .config file to tell an app to use .NET 1.1 after 2.0 came out. Not sure if that kind of thing still occurs. However, to answer your question, there are not error messages that make it to our logging...

We have a C# dll written in VS 2005 or .NET 2.0. The customer installed .NET 3.0 on the server and the application won't load. We duplicated the issue in our test system by installed .NET 3.0. Unfortunately, merely uninstalling 3.0 doesn't fix this problem. Does anyone know where to point me...

In VB you can put "stop" in place to halt code. Is there a way to do this with Javascript? _______ I love small animals, especially with a good brown gravy....

I believe that his problem was due to him setting the value of the variable every time the click even was run. If he merely sets that value and then reads that value with the click event, the result will remain constant. _______ I love small animals, especially with a good brown gravy....

Put the "startdate = "Started: " & date & " - " & time" into your form_load sub. Then call the variable on your click command.. such as this. Dim startdate Private Sub Command1_Click() MsgBox startdate End Sub Private Sub Form_Load() startdate = "Started: " & Date & " - " &...

I have a client that needs to have me query their SAP system from within an application that uses VBA. I have successfully written the portion that logs onto their SAP. I just have no experience with the syntax to use their custom RFC that they have provided me. I only know this much. the...

I have a client that needs to have me query their SAP system from within an application that uses VBA. I have successfully written the portion that logs onto their SAP. I just have no experience with the syntax to use their custom RFC that they have provided me. I only know this much. the...

Windows XP SP 2 _______ I love small animals, especially with a good brown gravy....