Search results for query: *

I've got a form that sends results using code from kav123 in a former post. (Thanks kav). <% Set oMail = Server.CreateObject("CDO.Message") oMail.From = "your-email@your-domain.com" oMail.To = "recipient@another-domain.com" oMail.Subject = "Here goes the email subject..." oMail.HTMLBody =...

A brief history about my exposure to ASP: From reading examples/faq's etc. I've done several asp pages that used SELECT, INSERT or UPDATE queries but in each case all the variables came from form data. (form = post) So, I know how to make a db connection, create a recordset, etc. My current...

I have a form that I want to display results based on the user who authenticated. For instance, SELECT * FROM TABLE WHERE USER = ::username:: I set the permissions for the site to give "DOMAIN/domain users" browse rights so they have to login. Is there a way to capture the login info and use...

I have a table with a column containing a term code (200810, 200820, 200730, etc). I want to create a view (we'll call it View2) with a column value with the most common term code for every record in the View2. I can get the value I want by using the following select query in a separate View...

I have a View that produces a one-to-many result list. What I need it to do is limit the "many" part to 5 instead of listing every possible result. Here's my query: SELECT TOP 100 percent a.GID AS Roommate1, b.GID AS Potential_Roommate2 FROM dbo.APPLICATION a INNER JOIN...

First a little background: I have an online applicaiton where incoming freshmen apply for campus housing. Part of the app lets them request their rommmate. The roommate requests have to be mutual. (We do random assignments for those that don't request a particular person but that's a...

I have a DTS job that runs daily. It imports a text file into a table. The problem is that the source that produces the text file has no validation to make sure that the data is the type it's supposed to be. Consequently, the text file can contain data that's not of the appropriate type such as...

I inherited a property control database that seems poorly set up. It's almost like each table was an a spreadsheet in a workbook. The database has a table named for each year the inventory is performed, i.e. 2003, 2004, 2005. . . They all have the same fields and types: Field Name Field Type...

I have the following code that I want to return the room assignment and occupants of that room. SELECT TOP 100 PERCENT A.Assignment, A.FirstName AS FN1, A.LastName AS LN1, B.FirstName AS FN2, B.LastName AS LN2 FROM dbo.housemail A LEFT OUTER JOIN dbo.housemail...

I have some VBA code that inserts the current date into a record when you click on an unbound button in my form. When you click, it does add the date to the table, but the changes aren't displayed in the form unless I refresh the form. I added me.refresh to the code and while that helps, it...

I'm doing a simple select query from a SQL database using a stored procedure. SELECT TOP 100 ID, FirstName, LastName, MailedDate FROM dbo.Table ORDER BY MailedDate What I can't figure out how to do is include the row number as a field in the stored procedure. I did some searching...

I've got a database with every dorm room on campus (thousands of rooms.) Most of the rooms are doubles so there are two beds. Currently the database will have two records for double rooms i.e. Beech 101 and Beech 101. I need to add a field that will denote the separate beds like Beech 101 A...