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

    How To Pull in Only Certain Information from a Web Site

    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?
  2. heathL

    Need to Select Year Only

    Thanks. It works!
  3. heathL

    Need to Select Year Only

    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'...
  4. heathL

    Error Type: ADODB.Recordset (0x80

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

    Use form value in email

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

    Login Failed for User '\'

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

    Incorrect syntax near '='

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

    Incorrect syntax near '='

    <% 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...
  9. heathL

    How to Validate Multiple Dates in Same Form

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

    How to Validate Multiple Dates in Same Form

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

Part and Inventory Search

Back
Top