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!

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

Search results for query: *

  1. dekesc

    Complex filtering of an ADO Recordset

    Actually, the app requirements have changed. Thus, I am using a different--and workling--SELECT. Not sure how to mark this issue as resolved. Any suggestion?
  2. dekesc

    Complex filtering of an ADO Recordset

    I changed the SELECT to my parameters and set it up for ADODB and got the following erro masg: Microsoft OLE DB Provider for SQL Server error '80040e14' Column 'CareMinistry_test_smallgroups.entry_Date' is invalid in the HAVING clause because it is not contained in either an aggregate...
  3. dekesc

    Complex filtering of an ADO Recordset

    I am not able to do the involved filtering of an ado recordset, as described below. I have tried several approaches but no success. Here's the scenario... 1. Using vbscript and asp 2. Databse = MS SQL (2008) 2. Table (care_Need_Entries) contains multiple rows of (varchar) columns...
  4. dekesc

    populate a form from ado sql recordset in php

    Sorry for not getting back on this but I have run into computer problems. I will return when that isseu is resolved.
  5. dekesc

    populate a form from ado sql recordset in php

    I have an asp file which uses vbscript to connect, open and use an ADO sqlserver recordset to populate HTML form elements within the asp file. The db has (the column of interest here) entry_Status as a varchar. The asp file does successfully populate the form element with the following code of...
  6. dekesc

    setting multiple "To" recipients using CDO.Message

    Well... here's one of those programming "solutions" that just doesn't have an explanation--at least I can't think of one. As I reported I used the variable format: seletedEmailTEST = "webmaster@thewebplusgroup.com; sales@thewebplusgroup.com" in the ".To" line of code as I recorded in my last...
  7. dekesc

    setting multiple "To" recipients using CDO.Message

    Turns out the ".cc" nor the ".bcc" allow for a variable, even one with just one email address. When I run the app with FireFox it tells me that that variable is undefined--although it is. As for replicating the Outlook multiple emaill address format, I replicated the stream that Outlook shows...
  8. dekesc

    setting multiple "To" recipients using CDO.Message

    I have not but will give your suggestion a try. Thanks for responding.
  9. dekesc

    setting multiple "To" recipients using CDO.Message

    I am trying to send an email dynamically to multiple recipients with the recipients defined within a variable. The code below works if I set selectedEmailList = "myemail@mindspring.com" (a single email address within quotes) but doesn't work if I set selectedEmailList =...
  10. dekesc

    porblem with quotes in building an ADO SELECT with multiple AND's

    Thanks to all who contributed all of the great ideas. As for my initial problem, George (gmmastros) is the solution I used which resolved the issue.
  11. dekesc

    Sending variable arugment to 2nd asp page.

    I forgot to mention that the code that does the send in the 1st asp does so via: <input colspan="1" align="left" bgcolor="#A2D8FF" type="button" onclick="location.href='http://servera.hosting.com/CBC-CareMinistry/RELM/CareEntriesView.asp?View=active&entryType=&listingfunctions'"> The send...
  12. dekesc

    Sending variable arugment to 2nd asp page.

    I want to pass a variable from one asp to another which then checks the value of the passed variable. The variable is a radio button which when clicked sets the value as 1, 2, 3 or 4. Here is the line that does the send: CareEntriesView.asp?View=all&entryType=&listingfunctions...
  13. dekesc

    porblem with quotes in building an ADO SELECT with multiple AND's

    Thanks for the tip. I can see where that approach can virtually eliminate the "single/double quote" query-building mistakes. Very helpful suggestion.
  14. dekesc

    porblem with quotes in building an ADO SELECT with multiple AND's

    Spot on, George! Thank you for taking the time to look into this. I have spent a ton of time trying to get the quotes right and now it is set up correctly. Darold
  15. dekesc

    porblem with quotes in building an ADO SELECT with multiple AND's

    In an asp file I am opening an ADO recordset and want to search for a unique record in the set that matches name, date and time in the database against the entries by a user. All three db fields are defined in the db as varchars. A form is used to enter the three values at the client side and...

Part and Inventory Search

Back
Top