Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by deanbri75

  1. deanbri75

    possible to use Omail.To with a variable?

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

    possible to use Omail.To with a variable?

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

    update query not from a form

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

    update query not from a form

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

    update query not from a form

    Here's what I ended up trying. Sadly, it didn't work. Is my syntax wrong somewhere? <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> </head> <body> dim tpg_trans_id...
  6. deanbri75

    update query not from a form

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

    update query not from a form

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

    database results based on user login

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

    Limit number of results in joined table

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

    View with most common value AS Column_Name

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

    Limit number of results in joined table

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

    Removing duplicate records from query results

    I don't know if this will help, my situation sounds similar and here's how I dealt with it. I'm sure there's a more elegant way but this worked well for me. I have to import data into TableA - this is the one with the duplicates. I want to copy rows into TableB but only if the row doesn't...
  13. deanbri75

    no duplicates - but not the normal no dup question

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

    no duplicates - but not the normal no dup question

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

    On Error Resume Next not working in transformation

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

Part and Inventory Search

Back
Top