Search results for query: *

I'm not sure where I should ask this question, but I'm trying to pull in only certain information from a site. For example, if I want to get weather only and display it on my site what is the best way to go about doing it?

Thanks. It works!

I want to write a select statement to find dates with 2002 only. If I use the entire date format for a single date like 1/1/2002 (see the code below), it works but I want to find all 2002 dates not just one. sql = "SELECT * FROM tblNewsStories Where archived='Yes' AND Date = '1/1/2002'...

I'm not sure how to fix this error ---- Error Type: ADODB.Recordset (0x800A0BB9) Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another. /intranetadmin/communications/PersonnelAnnouncementEmployeeReviewPost.asp, line 34 Here is the code. Line 34 is...

I'm looking for a script that would retrieve someone's name entered in a web form and use it in an email to make it more personal. Example, someone makes an inquiry using a web form: Instead of a generic "Thank You for .... ". I'd like to say "Dear Paul, Thank You for...

I searched and couldn't find this error. Here is my code, it is failing at the red area. Thanks. Dim cnNewsStories 'ADODB connection string Dim rsNewsStories 'Recordset variable Dim sql 'Holds the SQL statement Dim cnUser 'Holds the SQL user name Dim cnPassword 'Holds the SQL password Dim...

Thanks to all of you for your responses. Sunil's suggestion was correct in that I was using the wrong field name. It was so subtle -- I was using Pkey instead of pkey. I really appreciate your help. This forum is Great! Especially for a newbie to SQL like myself.

<% Dim rsWeb Dim sql Dim rsWebPKEY Dim pkey dim vRecipient, vCC, vBCC, vMailserver dim oMailer, mtxt, ftxt dim fso, f Dim OIRequestType OIRequestType = request.form(&quot;RequestType&quot;) sql = &quot;SELECT * FROM tblInformation WHERE pkey=&quot; & request.form(&quot;Pkey&quot;) Set rsWeb...

Thanks so much for your help. I made a few minor modifications and it worked like a charm. H

Here is the script I'm using for the date validation for ReleaseDate (in Red) but I also need to validate for EffectiveDate. How would I incorporate that? I am new at this so can use any help. Thanks. <script language = &quot;Javascript&quot;> // Declaring valid date character, minimum...