Comments by St0rmi - CodeProject

St0rmi 7-Nov-19 7:37am View

does the query

SELECT Distinct CAST(ms_date as Date) FROM tbltrackingrtt WHERE ms_date > '2017-11-01' AND heirarchy LIKE '%*145*%' AND category <> 0 AND category <> 145;

give you a result when executed directly in SQL workbench?

St0rmi 7-Nov-19 7:32am View

please check https://forums.iis.net/t/1181048.aspx, it's not at creation time but maybe it helps

St0rmi 7-Nov-19 7:30am View

Any chance you can check/log the SQL that's being executed on the server?

St0rmi 5-Nov-19 13:01pm View

Just try to change the values manually via regedit and you know

St0rmi 5-Nov-19 12:42pm View

Are you able to change cursor and background on the School Computer manually? If not, check GPO.

St0rmi 5-Nov-19 7:57am View

Try to use url.
If the structure is:

Website/images/file.png

Use:

url(/images/file.png)

more info:

https://stackoverflow.com/questions/5815452/how-to-use-relative-absolute-paths-in-css-urls

St0rmi 5-Nov-19 7:41am View

The thing is, every DOM element needs a unique ID. So if you are using a datagrid which repeats data, this means if you have a textbox1 in a datarow, this will be repeated for every row. So in order to make it work, there is a container "datarow1" for the 1st row which has a container "datagridxy" and the UniqueID of the TextBox changes to "xxx_datagrid1_datagridxy_textbox1_1" (or similar). But if you are in codebehind, you are able to access that TextBox as "Textbox1" if you already have the container of it (datarow1). ASP.NET is not able to know which textbox1 you want if there are 10 on the page and you invoke Page.Findcontrol. So finding a control with its ID is always on container level.

St0rmi 5-Nov-19 7:28am View

Assuming you are using MSSQL you could use the SQL Profiler to see the SQL query of the Subreport that's fired against the database. This will give you the chance of manually check the SQL against the database and find the error. If you still need help, it would be helpful to have some example data of the tables tblMain,tblScope and tblRatings.

St0rmi 5-Nov-19 7:11am View

The SSIS package contains SQL. As the error states it's at line 1 ,simply open the package and test the SQL against your database or post it here.

Comments by St0rmi (Top 9 by date)