Search results for query: *

I'd like to thank God and the Academy . . oh wait, that's a different thank you speech. The Mail.To suggestion worked perfectly. Seriously, I am very thankful for your help DaButcher and everyone else who answered my numerous questions that I've had with this project. Somehow I got dubbed...

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 =...

I know what the output will look like. Most of it is displayed on the screen after you complete payment. Thank you. Please print this receipt for your records. Name on Card: deanbri75 Account Number: xxxxxxxxxxxx0019 Expiration Date: 1207 Amount Paid: $ 1.00 Date and Time...

Thanks, Sheco. That's exactly how the process works. Not being a real programmer, (and the lack of documentation from touchnet) I wasn't sure how to get the parm values if they weren't coming from a form I'd written. Perhaps my SQL in the code above is off or maybe it's all wrong. I'll keep...

...set objconn1= server.CreateObject("ADODB.Connection") strconn1 = "DRIVER={SQL Server};SERVER=server.foo.bar;DATABASE=dbname;UID=username;PWD=********" objconn1.ConnectionString = strconn1 objconn1.Open strconn1 set objrs1 = server.CreateObject("ADODB.Recordset") strSQL1 = "UPDATE...

It may be doing that but I don't really know. When you configure touchnet there's two URLs you specify. One is the Post URL which is never seen and the Success URL which tells the user their payment went through ok. Documentation on this part is really poor. Here's what the manual says: The...

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 ended up reading a bunch of TSQL stuff on MSDN and found that a cursor was what I needed. It's fabulous dealing with one to many situations on a record by record basis. DECLARE @RM1 VARCHAR(50), @RM2 VARCHAR(50) DECLARE RM_CURSOR CURSOR FOR SELECT TOP 100 PERCENT a.GID AS RM1, b.GID AS...

...in a separate View (called View1) SELECT TOP 1 SLBRMAP_FROM_TERM FROM dbo.APPLICATION GROUP BY SLBRMAP_FROM_TERM ORDER BY COUNT(*) DESC My problem is how to incorporate this value into the column of my view. I'd like to use that select query AS Column_Name in my view. I...

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...

...TableB but only if the row doesn't already exist in TableB. In my case, I use the primary key to help with this. INSERT INTO TableB SELECT * FROM TableA WHERE (PrimaryKey NOT IN (SELECT TableB.PrimaryKey FROM...

Thanks so much 937 for the quick response. It did just the trick. I've inherited this project and will probably be posting a lot of questions on here as I work through all the nuances of it. It's kind of like in Star Wars when Luke ran off to fight Darth Vader. Sure, he had the force but...

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...

...such as 0818205 as a date instead of 08182005. To compensate for this I tried the following transformation script when importing that column: '********************************************************************** ' Visual Basic Transformation Script...

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...

Doing that just omits the FN2, LN2 on the 1st row for each duplicate assignment. Assignment FN1 LN1 FN2 LN2 CDV B206 Johnson Jasmine CDV B206 Rossouw Aileen Johnson Jasmine CDV B207 Hailey STANLEY CDV B207 Roberson Reginald Hailey STANLEY CDV B208 Brown Tamaneka CDV B208 Cammack LAUREN...

Sorry, I wasn't intentionally vague. The output I'm after should look something like this: Assignment FN1 LN1 FN2 LN2 CDV B206 Johnson Jasmine Rossouw Aileen CDV B207 Hailey STANLEY Roberson Reginald CDV B208 Brown...

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...

Thanks for the tips. Here's what ended up working for me: Dim cn As ADODB.Connection Dim rs As ADODB.Recordset Dim strSSN As String Set cn = CurrentProject.Connection Set rs = Me.RecordsetClone strSSN = Me!SSN.Value strSQL = _ "UPDATE dbo.PaperApp SET PriorityDate = CONVERT(CHAR(10)...