User Profile

Collapse

Profile Sidebar

Collapse
julian77
julian77
Last Activity: Aug 12 '06, 03:49 PM
Joined: May 5 '06
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • julian77
    replied to Populate Field
    in General
    hi,

    this might not be the smoothest approach, but if you are using access you should be able to do the following (SQL uses bit for this datatype where true = -1 and false = 0)

    (Presumes your column name is called active and you use a request.form-statement to update your table)

    Code:
    <select name="active">
<% if rs("active") = "True" Then %>
  <option
    ...
    See more | Go to post

      Leave a comment:

    • julian77
      replied to ADODB.Field error '800a0bcd'
      in General
      what does your query, i.e. select column_name from table_name, etc look like?

      do you want to list just one record or several ones?

      basically, there are no records in your table corresponding to your query.

      /jesper
      See more | Go to post

        Leave a comment:

      • julian77
        replied to field for mailto links in access
        in Access
        hi,

        it depends on if you want all the information to be stored in the database or not. for example, for a hyperlink you might just want to store "www.domainname .com" and keep the <a href="http://<%=rs("hyperlin k")%>"> etcetera-part in your code. One reason could be that you want to assign different css-classes to different links.

        with this approcah you would just store "info@domainnam e.com"...
        See more | Go to post

          Leave a comment:

        • julian77
          replied to Updating recordsets in MS SQL 2005 not working
          in SQL Server
          Arbert,

          Thanks for your reply.

          The connection is working, I can view, insert, etc recordsets from the database in SQL 2005. The problem arises when I try to update.

          Connection looks generically like:

          Code:
          Set DB = Server.CreateObject("ADODB.Connection") 
SQL = "driver={SQL Server};SERVER=ip-number;UID=userid;PWD=password;database=databasename"
          And the...
          See more | Go to post

            Leave a comment:

          • julian77
            started a topic Updating recordsets in MS SQL 2005 not working
            in SQL Server

            Updating recordsets in MS SQL 2005 not working

            Hi,

            I have recetly migrated from SQL 2000 to SQL 2005 and certain .asp-code that was working before, is no longer working.

            Retrieving, inserting, deleting recordsets are no problem, but when I try to update I run into problems.

            The following code works:

            Code:
            "UPDATE tblsomething SET column_name = 'something' "
            But in all my pages I have been using:

            Code:
            rs.Open
            ...
            See more | Go to post
            No activity results to display
            Show More
            Working...