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 SkipVought 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: *

  • Users: DeRoe
  • Order by date
  1. DeRoe

    Overview all sessions on application

    Digga, I appreciate your effort. Your suggestion will only give the session values of the user that browsed the site. What I need are all the session values of all the users that are browsing the site. Thx
  2. DeRoe

    Overview all sessions on application

    Hi, I was wondering if it is possible to make an asp page where i get an overview of all the sessionids with its sessionvariables. Is there an object that I can use to do this ? Example: - I have two sessionvariables: Session("var1") and Session("var2"). - Three people are...
  3. DeRoe

    blank field

    You better check if the image has some value instead for being empty (editorjalPic field = Null). <% image = CStr(rs(&quot;editorjalPic&quot;)) If Len(image) > 0 Then response.Write(&quot;not blank&quot;) %> <img src=&quot;images/editorjal/<%=image%>&quot; width=&quot;175&quot...
  4. DeRoe

    String Validation

    If you are trying to Replace a ' you should use FindString = &quot;'&quot; Replace(string, FindString, ReplaceWithstring) If you are looking for the &quot; you use FindString = &quot;&quot;&quot;&quot; '1st &quot; is to open the string '2nd en 3th &quot; is to get a &quot; in the string...
  5. DeRoe

    Using ASP to execute SQL

    First you check if there is a record with the same UserName. Is this not the case you insert a new record. Set rsUser = oConn.Execute(&quot;SELECT Username FROM Users WHERE Username = '&quot; & Request(&quot;Username&quot;) & &quot;'&quot;) If rsUser.EOF Then 'No record found with the same...
  6. DeRoe

    Asp and Sql syntax

    You can try to explicitly convert the rs(&quot;Cellnum&quot;) to a Lng like this: Select Case CLng(rs(&quot;Cellnum&quot;)) Case 66 SmallMachop = rs(&quot;Efficiency&quot;) Case 36 SmallAssop = rs(&quot;Efficiency&quot;) End Select or use strings: Select Case...
  7. DeRoe

    to many parsed variable

    If you are not sure about a SQL query you should try it in the database itself. Then you know that at least your query is correct. Try the following query: Select * From CUSTOMER where src in (a,b,c,d) With ( and without ; Greets

Part and Inventory Search

Back
Top