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 Wanet Telecoms Ltd 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 Olav

  1. Olav

    WinXP Pro and IIS problem

    Is the ID-field a text field? If it's a number field then you should omit the single quotes in the sql: sql = sql & "INSERT INTO MyTable (id, name, age)" sql = sql & "VALUES (" & ID & ",'" & Name & "', '"& Age &"');" Take a look at the...
  2. Olav

    Write HTML title to ASP page

    I think that it's possible if you use a session variable. When you know the title then define the session variable: <% Session(&quot;Title&quot;)=&quot;theTitle&quot; %> or use a variable <% Session(&quot;Title&quot;)=theVariable %> and in the asp pages...
  3. Olav

    Problems pulling records containing Single Quotation marks

    Try this: CompanyName = Replace(CompanyName,&quot;'&quot;,&quot;?&quot;) before you set up the SQL and in your SQL ... where CompanyName like '&quot; & CompanyName & &quot;' ..... Olav

Part and Inventory Search

Back
Top