Search results

Hi, I have gotten some help here before which has allowed me to convert a bunch of T-SQL statements to MySQL. But I am stumped on this one (this is just the IIF part): IIf([tlkpSUHorz]![SUHorz]='Segment',[tlkpSUHorz]![SUHorz] & ' ' & [tblPD]![SUHorzID], (IIf([tlkpSUHorz]![SUHorz]='Half' Or...

Hi, I am converting what I believe is T-SQL into MySQL. I have done pretty good so far but I ran into this and needed some help explaining this part of the query: SELECT tblStratProfile.ProfileNum, tlkpProfileView.ProfViewDesc, IIf((IsNumeric([tblStrat]![StratNum])),[tlkpSUTyp]![SUTyp] & ' '...

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

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

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