Recent content by sugarflux

Ugh :p Sounds like you really need to write a new website not using frames! I'm afraid I don't have any facility for testing this as I haven't used frames for many many years... However I think you should be able to find the frame using somthing along the lines of...

Yes - I am, of course, already setting it to nothing in the class_terminate. I am also setting the instance of the Database class itself to nothing at the end of each page to ensure the class_terminate is fired. This is why it was such a peculiar error and I have had to put it down to the...

In case this is useful to anyone else I traced the error down to the following line which is happening in class_initialize() set m_Connection=CreateObject("ADODB.Connection") For some strange reason the error was occurring when trying to set up the connection object. I think it must be to do...

It's not getting far enough through the process when the error occurs. It's literally failing at the first line: <% set DB=new Database %> So it must be a problem in the Database class but without a line number or a proper error message to go on and I'm a bit stuck. I believe it's falling over...

Apologies - I've just realised I omitted the ID attribute of the link - the link would need an ID for the function to find it... <a id="MyReportLink" class="nav" href="../OEE/OEE_ChartYear.asp?cYear=" target="cpOTIF_Main" onclick="whatYear(event,this.id);">OEE 2014</a> ~S~

It's not the tidiest solution but you could achieve something similar in Javascript. <a class="nav" href="../OEE/OEE_ChartYear.asp?cYear=" target="cpOTIF_Main" onclick="whatYear(event,this.id);">OEE 2014</a> <script type="text/javascript"> function whatYear(e,el){ e.preventDefault()...

I absolutely love chart.js. http://www.chartjs.org/ I know you asked for ASP and this is JavaScript but it's really simple to create the charts in JavaScript after the page has loaded. From ASP all you need to output to the screen is a canvas element and (if you like) provide the data via a JSON...

Hi all I've got quite a heavy traffic classic ASP site (I know it needs converting to .Net at some point) which runs fine 90% of the time but occasionally I get an error 'ASP 0115' Unexpected Error. A trappable error (C0000005) occurred in an external object. The script cannot continue running...

George This was awesome information - thanks! This completely explains - very simply - why the database was not changing in size due to my lack of understanding. My indexing is actually very simple, generally just primary keys. The data is heavily normalised and there is very little searching...

As an extra note I've started to try to convert some of my columns to reduce the size on disk. For example, when the database was built the majority of numeric columns were created as INT even when they would contain smaller numbers. So changing these into TINYINT or SMALLINT I would've expected...

Hi George Many thanks for your advice - and I agree having a 2GB limit is bad. However, there are, unfortunately, issues with all of the above! Firstly, I don't think I actually have access to the log file - certainly not to change the backup method. I also don't believe I have access to...

Thanks gmmastros name fileid filename filegroup size maxsize growth usage db00000000 1 X:\MSSQL\Data\db00000000.mdf PRIMARY 894336 KB 1024000 KB 25% data only db00000000_log 2 X:\MSSQL\Data\db00000000_log.ldf...

Hi all Hoping someone may be able to help me out as I'm stumped with this one... I have a 'hosted' MS SQL Server (meaning I can't access the DB directly in Management Studio, I use RazorSQL and/or MyLittleAdmin). There is a size restriction on the DB of 2GB - currently my DB stands at 1500 MB...

Well - it looks like I've managed to solve this issue before anyone else got round to helping out! For information in case anyone else is searching for something similar - I created a Schema.ini file in the same location as my import csv file. Within the file i specified: [MyFile.csv]...

Hello all. Hoping someone may be able to help me with this one... I've had an ASP/VBScript import routine setup for a long time which [enormously simplified] collects a csv file from a server and imports the contents into an Access table. There are usually approx 14 columns and around 640k...