Search results for query: *

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?

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

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

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

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

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

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

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

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

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.

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

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

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

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

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