Recent content by stanhook

@cheekybuddha This is an existing table (all of them are) no records are being added or changed. I haven't changed anything with the structure. All I did was convert the tables from Access over to MySQL by exporting them as a CSV file. I have done about 100 of these and this is the first...

@cheekybuddha So the command shows FeNum should be NULL CREATE TABLE `tblPD` ( `id` varchar(5) DEFAULT NULL, `site` varchar(15) DEFAULT NULL, `pd` varchar(6) DEFAULT NULL, `inputstamp` varchar(10) DEFAULT NULL, `inputinitials` varchar(13) DEFAULT NULL, `dateopened` varchar(255)...

I think I have it fixed. For some reason the table does not have NULL for FeNum. It is empty. Not sure why or what happened. I will test more but this may be fixed.

@cheekybuddha So I ran each of those and the count was 0. No errors at all. In the WHERE statement if I leave the Site and change AND to OR and leave out the SUNum I get back 1700+ records. If I remove the site and leave in the SUNum I do not get any records back. I also tried this in the...

@cheekybuddha Unfortunately your code returned the same empty results. I know the query returns results because I get them on the old website. So the data is returned for the variables I added. I don't get any errors, just no results using the converted query. I just feel like there must be...

Thank you all for your help and thought's! @cheekybuddha I will try that in a bit and see if that works. Just to note, I am converting the old query into MySQL. This is the old query copied directly from the code: SELECT tblPD.Site, tblPD.SUNum, tblPDSCP.SCPOrder, tblPD.PD...

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

@Gasman @cheekybuddha Awesome help and thanks for explaining it. That was exactly what I needed and the code shared got it working. You all rock!

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

@Pat Hartman Thanks for moving this. I am new here and didn't even realize there was a forum for these questions. Thank you all for your responses and help!! From the information you all provided I was able to come up with this for my WHERE which worked: WHERE tablename like 'tblPD' AND...

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, Thank you all for your response. I had eventually assumed it was for a collection, but it still didn't make sense because there is only a single value in the URL. This is part of the statement where it is included: SELECT tblPhotoManage.Date, tblPhotoSU.RecordCounter, tblPhotoSU.Site...

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

@The_Doc_Man This is extremely kind and awesome of you to take the time to explain it in a way I can understand! I'll re-read it a few times so it all can sink in but this has been incredibly helpful!! Thank you all for your great explanation and taking the time to help me understand what this...

Thank you all so much!! This has been extremely helpful for me being new to all of this. One thing, the '!' and '.', it is simply being used because it is being used in control or form? In my case it is a form that is referencing the statement. Do they have any other meaning? CDbl -...