Search results

  1. S

    T-SQL conversion

    Hi, I am pretty new to T-SQL but I have this on an old ASP page: sqlDataDict = "SELECT tblDataDict.TableName, tblDataDict.FieldName, tblDataDict.Description" sqlDataDict = sqlDataDict & " FROM tblDataDict" And then down the page there are a bunch of these, each one requesting different data...
  2. S

    Old Access Translation of & Request("SUNum")(1) &

    Hi, I am new to access and I am trying to update a site I have inherited. There is an SQL statement in an ASP page that is requesting data from the URL: & Request("SUNum")(1) & This is in the URL: &SUNum=110& I am not understanding what the (1) is for. It is probably really common I am...
  3. S

    Statement Interpretation [ ] ! [ ], [ ] . [ ] and CDbl

    HI, I am trying to work with an access 2007 database and update a website. I have a bunch of queries I need to interpret and bring them up to date. Can someone please tell me what this means: CDbl(IIf(IsNumeric( [tblSU]![SUNum]),[tblSU]![SUNum], Left([tblSU]![SUNum]...
Top Bottom